Help with worksheet function

[Gadgetman]

I need help with a worksheet function for number of accidents that
have certain catagories assigned.

Column B of my worksheet is to be labled either "Reportable" -or- "Non-
Reportable".
Column C is to be labled either "EK" -or- "EA" (codes for different
locations)

I need to have a formula/function that calculates how many accidents
that are marked "Reportable" AND have the "EK" designations. Same with
"Reportable" AND "EA" etc. The worksheet is too large to count them by
eye so a formula would be great. If anyone can help, I'd appreciate
it.

Thanks

 

[zvkmpw]

Column B of my worksheet is to be labled either "Reportable" -or- "Non-

Reportable".
Column C is to be labled either "EK" -or- "EA" (codes for different
locations)

I need to have a formula/function that calculates how many accidents
that are marked "Reportable" AND have the "EK" designations. Same with
"Reportable" AND "EA" etc.

Here's one way with Excel 2003.

In D14 put
Not Reportable
Not Reportable
Reportable
Reportable

In E1:E4 put
EA
EK
EA
EK

In F1 put
=SUMPRODUCT((A$1:A$1000=D1)*(B$1:B$1000=E1))
and copy it down to F4.

The table in D1:F4 should have the four counts desired.

 

[Pete_UK]

You have other suggestions at your other duplicated post.

Pete