SUMIF with two conditions

[Fred Holmes]

Is there a way to use SUMIF or some similar function with two
conditions?

I have a credit card transaction listing downloaded from my bank.

I want to sum the purchases (amount is >0) only within a date range
(another column has the dates). It's easy to formulate the SUMIF with
either of the two conditions, but I don't see how to apply both.

Thanks,

Fred Holmes

 

[Don Guillett]

=sumproduct((daterng>a1)*(daterng<=a2)*amountrng)

 

[Guest]

use the AND() function within sumif

 

[Peo Sjoblom]

No, that will not work