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

One way

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


Regards,

Peo Sjoblom

"Vibha" wrote:

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

One way:

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

In article ,
"Vibha" wrote:

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