Countifs

Dear all,

i have list like this.

Abc_001
abc_001
abc_001
abc_002
abc_002
abc_002
abc_003
abc_003
abc_003



and i want count how many abc_001, abc_002 & abc_003..

Is that possible

i know we can use =countif(a1:a100,"abc_001")

but i want if (a1:a100, start with abc then count)

is that possible

i hope u all understand

plz help me

thanks in advance...

Mjr

Originally Posted by benishiryo

hi Mjr, try:
=COUNTIF(A1:A100,"abc_*")
or
=COUNTIF(A1:A100,"abc*")

THANK YOU benishiryo,


ITS WORKING

IF ABC & BCA THEN HOW TO COUNT

CAN U TELL ME

MJR

Originally Posted by mjr10891

THANK YOU benishiryo,


ITS WORKING

IF ABC & BCA THEN HOW TO COUNT

CAN U TELL ME

MJR

You try this :
=COUNTIF(A1:A100,"abc*")+COUNTIF(A1:A100,"bca*")
~~~~~~~

Originally Posted by abubaniyan

COUNTIF(A1:A100,or("abc_*","bca_*"))

The result returns 0????

Originally Posted by sunflowers

you try this :
=countif(a1:a100,"abc*")+countif(a1:a100,"bca*")
~~~~~~~

ok thank u

mjr

Originally Posted by abubaniyan

countif(a1:a100,or("abc_*","bca_*"))

result always coming " 0 "