Monthly Totals
 

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!

Monthly Totals
 

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!

Monthly Totals
 

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!