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

=sumproduct((daternga1)*(daterng<=a2)*amountrng)

--
Don Guillett
SalesAid Software

"Fred Holmes" wrote in message
...
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

use the AND() function within sumif
--
Gary's Student


"Fred Holmes" wrote:

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

No, that will not work

--
Regards,

Peo Sjoblom


"Gary's Student" wrote in message
...
use the AND() function within sumif
--
Gary's Student


"Fred Holmes" wrote:

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