Array formula acting as it shuld ... but
Try this non-array version:
=SUMPRODUCT(--(ISNUMBER('2008'!B$2:B$746)),--(MONTH('2008'!B$2:B$746)=$I4))
--
Biff
Microsoft Excel MVP
"DavidK" wrote in message
...
I have the following array formula:
{=SUM(IF(MONTH('2008'!B$2:B$746)=$I4,1,0))}
In col I I have values 1 to 12. I would expect this to give me a
summary of monthly occurences based on column B which contains dates.
The problem is in the first month. It seems that if the cell is
blank, the ligical retuirns 1, so with nothing in column B the formula
returns a value of 45.
I have tried ISBLANK with no success, since the values in column B are
continually being added to.
All other months work except 01. Any suggestions?
David M. Kellerman
|