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?