Conditional Count

R

Ralph

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

Ralph

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

Ann Scharpf

I'm jsut re-posting an answer that helped me last summer:

Hi!

Within the SUMPRODUCT formula given there are two implicit IF
structures that return TRUE or FALSE. The -- coerces these to 1 and 0.
Only if both structures return TRUE (1) will the result of multiplying
them equal 1 which will add 1 to the sum of the products.

For more detailed explanations do a Google search on Unary Minus.
 
Top