View Single Post
  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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