Can function be applied to range in sumif prior to criteria ch
Thanks for the replies!
I finally got it going by using Bob's code as a starting point.
Thanks again for all the replies,
CW
"Bob Phillips" wrote:
No, use SUMPRODUCT
=SUMPRODUCT(--(MONTH(date_range)=1),--(date_range<""),amount_range)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Cheese_whiz" wrote in message
...
Hi all,
I have a range of dates I'm using for the first argument in a sumif
function. I need to convert those dates to a single month number (one for
each date) prior to running the criteria check found in the second
argument
of the sumif function.
Is that possible?
tahnks,
CW
|