COUNTIFS formula question

[Yogachick]

I have a spreadsheet that has symbols representing status. I have 3 letter
variables that I want to calculate over a range of columns. The 3 symbols
are R, RS and $. Each of them would represent the number 1. I have gone
into the help and tried to enter the COUNTIFS formula as they say I should
and I keep getting an error that it is invalid. Here is the formula that I
am entering:

=COUNTIFS(B3:AM3, "R", [B3:AM3, "RS"], [B3:AM3, "$"])

The error keeps popping up at the "R" and I have tried it without the quotes
and I get the same error.

 

[Bob Phillips]

Do you want R OR RS OR $? If so, try

=SUM(COUNTIF(B3:AM3, {"R","RS","$"}))

 

[Eduardo]

try

=SUMPRODUCT((B3:AM3="R")+(B3:AM3="RS")+(B3:AM3="$"))

 

[Yogachick]

Eduardo - I wanted to calculate all three and this worked like a charm.

Thank you so much - have a great weekend.
--
Jennifer D.

try

=SUMPRODUCT((B3:AM3="R")+(B3:AM3="RS")+(B3:AM3="$"))

I have a spreadsheet that has symbols representing status. I have 3 letter
variables that I want to calculate over a range of columns. The 3 symbols
are R, RS and $. Each of them would represent the number 1. I have gone
into the help and tried to enter the COUNTIFS formula as they say I should
and I keep getting an error that it is invalid. Here is the formula that I
am entering:

=COUNTIFS(B3:AM3, "R", [B3:AM3, "RS"], [B3:AM3, "$"])

The error keeps popping up at the "R" and I have tried it without the quotes
and I get the same error.

 

[Eduardo]

thank you for your feedback, Have a great weekend

Eduardo - I wanted to calculate all three and this worked like a charm.

Thank you so much - have a great weekend.
--
Jennifer D.

try

=SUMPRODUCT((B3:AM3="R")+(B3:AM3="RS")+(B3:AM3="$"))

I have a spreadsheet that has symbols representing status. I have 3 letter
variables that I want to calculate over a range of columns. The 3 symbols
are R, RS and $. Each of them would represent the number 1. I have gone
into the help and tried to enter the COUNTIFS formula as they say I should
and I keep getting an error that it is invalid. Here is the formula that I
am entering:

=COUNTIFS(B3:AM3, "R", [B3:AM3, "RS"], [B3:AM3, "$"])

The error keeps popping up at the "R" and I have tried it without the quotes
and I get the same error.