Need help on Sumif formula

[abhay_547]

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]

Try

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

[abhay_547]

Thanks a lot it's working fine now.