I'm kind of amazed it worked at all.

First, this shouldn't be array entered (ctrl-shift-enter) if that's what you
meant. Just hitting enter will be sufficient.

Second, you're missing a final close parenthesis at the end.

And lastly, don't you want all the ranges to be 1:1000 or 1:2000?



imjustme wrote:

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

--

Dave Peterson