View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jock Jock is offline
external usenet poster
 
Posts: 440
Default Formula giving wrong result

Why does this:
=SUMPRODUCT(--(MONTH(B$7:B$998)=1))
return 992 when the entire column B is empty?
The other 11 permtations work as one would expect, but this particular one
counts 'blank' as January!
Any ideas?

tia
--
Traa Dy Liooar

Jock