How to define multiple date criteria in 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.

Thanks a lot for your help in advance.

 

[Aladin Akyurek]

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.

Thanks a lot for your help in advance.

Let E2 house a start date and F2 an end date.

In G2 enter:

=SUMIF(A:A,">="&E2,B:B)-SUMIF(A:A,">"&F2,B:B)

 

[abhay_547]

Thanks a lot it's working fine now.

 

[Aladin Akyurek]

Thanks a lot it's working fine now.

Great. Thanks for providing feedback.