=SUMPRODUCT(--(A1:A100=1),--(B1:B100="R"))

modify as needed.

HTH
GerryK

"Ralph" wrote:

I have two columns, not adjacent, I need to count the number of times the
number 1 appears in the first column at the same time the letter R appears in
the second column in the same row. Data appears in up to 500 rows.
Can I do this with a single conditional count formula that references a
range of cells?