Why would it count blank cells?


--

Regards,

Peo Sjoblom

"imjustme" wrote in
message ...

Hi all!!

I have been trying to figure out how to NOT have excel count blank
cells when it is counting my information that my formulas are telling
it to count. This is my current formula (array):


=SUMPRODUCT(--(oc!$C$1:$C$1000=435),--(oc!$H$1:$H$2000="approved"),--(oc!$D$
1:$D$1000="telemedicine")

I have to put a space in each blank cell (which could be a bunch)

Thanks

Dee


--
imjustme
------------------------------------------------------------------------
imjustme's Profile:
http://www.excelforum.com/member.php...o&userid=26854
View this thread: http://www.excelforum.com/showthread...hreadid=480665