Count cells in database

  • Thread starter Thread starter Alfred
  • Start date Start date
A

Alfred

Hi!

I want to count cells in a database and deliver the answer in a single cell.
Example: if the arraya b2:b10 contains the answers and c2:c10 contains the
right answer, I would like to count tha amount of right answers and deliver
it to a cell. Thanx!
 
=countA(C2:C10)

or if you are matching B to C

=SUMPRODUCT(--(B2:B10=C2:C10),--(B2:B10<>""))
 
Back
Top