PDA

View Full Version : Need help on Sumif formula



abhay_547
06-21-2011, 09:27 PM
Hi All,

I need a help on sumif formula .i.e. I want to sum the numbers present in a column based on multiple criteria. Here is what I have. Column A has Dates, Column B has Amounts. and I want to sumif the numbers between two dates for e.g. row I9 has Start date and row J9 has end date so I want the sumif formula to look into column A for the start date first and then the end date and sum all the numbers which are there in column B .i.e. Amount column. Attached is the excel sheet for your reference.

Thanks a lot for your help in advance. :)

Bob Phillips
06-21-2011, 11:49 PM
Try

=SUMIF(A2:A30,">="&I9,B2:B30)-SUMIF(A2:A30,">"&J9,B2:B30)

abhay_547
06-22-2011, 08:23 PM
Thanks a lot it's working fine now. :beerchug: