How to count Match Values with Multiple Criteria?

[raja616]

Hi Team,
I have created named range as "castingTable" like below format.

Category Type
PCC F2 F3 CF1 CF2
Footings CF4 F3
Footings F2 F4 CF2


When I use CountIF(CastingTabe ,"F2") getting count = 2 that's right .
But I requirement for PCC it has to show 1 and for Footings 1.

How to count in named range with multiple criteria for each category.

Thanks
Raja

[tim201110]

try COUNTIFS

[raja616]

Tried its not working, its counting "PCC" as one match and F2 two matches, totally 3 counts.

[José Augusto]

Hi
In your example, how many columns does your "ranged name" have?

What are the categories?