Double Criteria

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

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

--
Don Guillett
SalesAid Software
[email protected]
"DRANDON" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Thanks man, that works outstanding!

Drandon

glad to help

--
Don Guillett
SalesAid Software
[email protected]
"DRANDON" <[email protected]> wrote in
message news:[email protected]...
>
> Thanks man, that works outstanding!
>
> Drandon
>
>
> --
> DRANDON
> ------------------------------------------------------------------------
> DRANDON's Profile:
> http://www.excelforum.com/member.php...o&userid=35901
> View this thread: http://www.excelforum.com/showthread...hreadid=556923
>