View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

=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