Count If met any one of multiple criteria

[lukestkd]

Hi all,
As per the title. What formula would I use if I wanted to count a range where cells meet any one of a number of criteria? (not all of multiple criteria, any one)

Many thanks

Luke

[bajdr47]

It would depend how many criteria you require.

First i would have a look at countifs,

if that didnt meet your needs. i would try sumproduct, but u would need an understanding of this function,
can u be more specific

baj

[lukestkd]

So for example I have the following formula

Please Login or Register  to view this content.

However I think this is checking for cells that have ALL of the criteria above, I need it to check cells that have any ONE of the following criteria in the named range 'progmonethnicity':
"Black - African"
"Black Caribbean"
"Chinese"
"Gypsy/Roma"
"Indian"
"Kashmiri Pakistani"
"Other Asian"
"Other Pakistani"
"White and Asian"
"White and Black African"
"White and Black Caribbean"
"Any other Black background"
"Any other ethnic group"
"Any other mixed background"
"Information Not Yet Obtained"
"Refused"

[lukestkd]

Can anyone help on this?

[JosephP]

=SUM(COUNTIFS(progmonethnicity,{"Black - African","Black Caribbean","Chinese","Gypsy/Roma","Indian","Kashmiri Pakistani","Other Asian","Other Pakistani","White and Asian","White and Black African","White and Black Caribbean","Any other Black background","Any other ethnic group","Any other mixed background","Information Not Yet Obtained","Refused"},'Progress Monitor'!$AL$3:$AL$42,C$2))

probably easier to have a grouping column in the source data

[lukestkd]

=SUM(COUNTIFS(progmonethnicity,{"Black - African","Black Caribbean","Chinese","Gypsy/Roma","Indian","Kashmiri Pakistani","Other Asian","Other Pakistani","White and Asian","White and Black African","White and Black Caribbean","Any other Black background","Any other ethnic group","Any other mixed background","Information Not Yet Obtained","Refused"},'Progress Monitor'!$AL$3:$AL$42,C$2))

probably easier to have a grouping column in the source data

Amazing! Thank you!