I do not know why it is counting the blank cells. There used to be
information in them and then I deleted it out. It will not do it for
every month just 3 out of the 12.

=SUMPRODUCT(--(ma!$C$1:$C$1000=690),--(ma!$H$1:$H$1000="approved"),--(ma!$K$1:$K$1000="outpatient")

The reason I was missing a ")" is because when you do C+S+E it will add
it when it adds the }.

=SUMPRODUCT(--(ma!$C$1:$C$1000=690),--(ma!$H$1:$H$1000="approved"),--(ma!$K$1:$K$1000="outpatient"))
This is the formula I should use????


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