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.