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!

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).


In article ,
"Jasmine" wrote:

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!

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

"JE McGimpsey" wrote:

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).


In article ,
"Jasmine" wrote:

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!