SUMproduct((G55:G119="Inpatient")*(I55:I119="CARDI O"))

--
Don Guillett
SalesAid Software

"DRANDON" wrote in
message ...

I wish to check two columns of data for the purpose of counting.
1st column is either "Inpatient" or "Outpatient". The 2nd is either
"Cardio", "General".

I want to count how many "Inpatient" are "Cardio"

My formula looks like this -
SUM(IF((G55:G119="Inpatient")+(I55:I119="CARDIO"), 1,0))

The result is #VALUE

What gives?

Currently, I'm using a PivotTable that works ok but I'de rather use a
formula so I can easily format a nice looking table.

Can anyone help me?

Drandon


--
DRANDON
------------------------------------------------------------------------
DRANDON's Profile:
http://www.excelforum.com/member.php...o&userid=35901
View this thread: http://www.excelforum.com/showthread...hreadid=556923