formula to count codes

[kshitij_dch]

Hello folks ,

I have some codes that i want to count in each row , for that i am looking for a formula to count those codes

[TABLE="width: 320"]
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]1[/TD]
[TD="class: xl63, width: 64"]2[/TD]
[TD="class: xl63, width: 64"]3[/TD]
[TD="class: xl63, width: 64"]4[/TD]
[TD="class: xl63, width: 64"]6[/TD]
[/TR]
[TR]
[TD="class: xl63"]PL[/TD]
[TD="class: xl63"]SL[/TD]
[TD="class: xl63"]CL[/TD]
[TD="class: xl63"]P[/TD]
[TD="class: xl63"]UL

[/TD]
[/TR]
</tbody>[/TABLE]

in the above table i have codes as PL , SL , CL , UL , P.... I need to count the codes (SL+UL+CL+PL) exclude P

My answer will be 4

any formula for this ?

 

[Swayzy]

In an empty cell, first use the function counta in the row with codes. This finds the total number of entries. Then subtract that with a countifs function with "P" as criteria and row with codes as criteria range.

 

[RoryA]

If you just need to exclude P, you can do that with COUNTIF:

=COUNTIF(A1:F1,"<>P")

for example.