Monthly Totals

J

Jasmine

I have the following formula on my worksheet
=SUMPRODUCT(--(Closed!$B$1:$B$5000="Maxwell
R"),--(MONTH(Closed!$W$1:$W$5000)=10)). It works great for cells that have a
date in them, but some of the cells are blank. This is causing a #VALUE
error. Is there any way around this? Thanks!
 
J

JE McGimpsey

A truly blank cell won't give you a #VALUE! error - do your "blank"
cells have space characters in them (which are text, so will cause
MONTH() to throw an error).
 
J

Jasmine

The cells are blank, but my range was encompassing the header, which is text.
Thanks for your help!
 
Top