Thread
:
SUMIF with two conditions
View Single Post
#
2
Don Guillett
Posts: n/a
=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
Reply With Quote