Totals based upon multiple criteria (COUNTIF)

[snpperhd]

Hi, I have a work schedule created in Excel that has various single letter designators for duties performed. X indicates at work, S indicates on Standby, C for Comp Day etc... I currently use a COUNTIF formula to total the "X"s to show total number of people at work; how can I add multiple variables to this formula to total other designators which are also at work like the "S"s for standby? Below is my current formula. Thanks.
=0+(COUNTIF(C10:C27,"X"))

snpperhd

 

[T. Valko]

Hi, I have a work schedule created in Excel that has various single letter designators for duties performed. X indicates at work, S indicates on Standby, C for Comp Day etc... I currently use a COUNTIF formula to total the "X"s to show total number of people at work; how can I add multiple variables to this formula to total other designators which are also at work like the "S"s for standby? Below is my current formula. Thanks.
=0+(COUNTIF(C10:C27,"X"))

snpperhd

Try one of these...

=SUM(COUNTIF(C10:C27,{"X","S"}))

=COUNTIF(C10:C27,"X")+COUNTIF(C10:C27,"S")

 

[njimack]

=sumproduct(--(isnumber(match(c10:c27,{"x","s","c"},0))))

 

[snpperhd]

Thanks to 'T Valko' & 'njimack' for the quick response...T Valko's =SUM(COUNTIF(C10:C27,{"X","S"})) worked. I tried the two other options, but each didn't quite work. Thanks again.

snpperhd

 

[T. Valko]

Thanks to 'T Valko' & 'njimack' for the quick response...T Valko's =SUM(COUNTIF(C10:C27,{"X","S"})) worked. I tried the two other options, but each didn't quite work. Thanks again.

snpperhd

You're welcome. Thanks for the feedback!