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?

=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?

Fantastic!
Just so I learn more - what is the function of the dashes before the array?,
and I didn't know you could put conditions onto an array eg: A1:A100=1.
Would Countif or CountA have worked?

"GerryK" wrote:

=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?