sum if - month question
One way:
=SUMPRODUCT(--(TEXT('Raw Data'!H4:H18,"mmm")="Jan"))
Biff
"paula k" wrote in message
...
I am using the following formula (and it works!) to calculate the number of
dates that equal january, feb, and so on.
=SUMPRODUCT(--(MONTH('Raw Data'!H$4:H$18)=1))
Within the raw data, I also have the word "unscheduled" where a date
should
belong. I am now getting errors with my formula. How do I add - if the
cell
doesn't = unscheduled, then sum product?
Thanks!!
|