Count formula

[Vibha]

Hi,

I have text ABC, CDE in column A and this text in
repeated. I just want to count number of ABC and number
of CDE in the spreadsheet. It is a huge speradsheet, I
don't want to sort and do a manual count

Thanks

 

[Peo Sjoblom]

One way

=SUMPRODUCT(--(A2:A500={"ABC","CDE"}))


Regards,

Peo Sjoblom

 

[JE McGimpsey]

One way:

=SUM(COUNTIF(A:A,{"ABC","CDE"})