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.

--
Jennifer D.

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

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


--
__________________________________
HTH

Bob

"Yogachick" wrote in message
...
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.

--
Jennifer D.

try

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

"Yogachick" wrote:

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.

--
Jennifer D.

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

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


"Eduardo" wrote:

try

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

"Yogachick" wrote:

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.

--
Jennifer D.

thank you for your feedback, Have a great weekend

"Yogachick" wrote:

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

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


"Eduardo" wrote:

try

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

"Yogachick" wrote:

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.

--
Jennifer D.