Count of data [SOLVED]

[shantraj.antin@gmail.com]

Hi Dear Team,


I have the below data and need to count based on the condition.


1-Jun 2-Jun 3-Jun 4-Jun 5-Jun 6-Jun 7-Jun

VL B B PL SL


I need to the formula which counts only for VL,PL and SL and ignore B and blanks.


Thanks for your support.

 

[SirJB7]

Hi, Shan!


The rude and straight way:

=CONTAR.SI(A2:G2;"VL")+CONTAR.SI(A2:G2;"PL")+CONTAR.SI(A2:G2;"SL") -----> in english: =COUNTIF(A2:G2,"VL")+COUNTIF(A2:G2,"PL")+COUNTIF(A2:G2,"SL")


The lazy and tricky way:

=CONTAR.SI(A2:G2;"?L") -----> in english: =COUNTIF(A2:G2,"?L")


Other ways available but more complex.


Regards!

 

[shantraj.antin@gmail.com]

hi SirB7,


Thanks for your responce... but =COUNTIF(A2:G2,"VL")+COUNTIF(A2:G2,"PL")+COUNTIF(A2:G2,"SL")


is resulting as one instead of 3, where its VL PL and SL are aprearing in the range.

 

[SirJB7]

Hi, Shan!

Assuming your data is in row 2 from cell A2 thru G2 (as per your previous posted row with values 1-Jun thru 7-Jun), both formulas display a 3 and not a 1.

Regards!

 

[shantraj.antin@gmail.com]

hi SirB7,


You are right I had some to be corrected.... its working. Thank you.

 

[SirJB7]

Hi, Shan!

Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.

Regards!