Does SUMIF in Excel, take multiple criteria input?
=SUMPRODUCT(--(ISNUMBER(D10:D40),--(MONTH(D10:D40)=1),--(E10:E40=G3),F10:F40
)
--
Regards,
Peo Sjoblom
"Xray_Dave" wrote in message
...
I am trying to SUM by month, what is spent on different products or
buckets.
The formula I have been trying to make work is:
'=SUMIF(D10:E40,(AND(MONTH(1),G3)),F10:F40) whe
RANGE=D10:E40. Months are in Col D10:D40, and buckets are in E10:E40.
CRITERIA=(AND(MONTH(1),G3))
SUMRANGE=F10:F40
I have tried several others but don't seem to get even close.
Thanks
Dave
|