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

1	2	3	4	6
PL	SL	CL	P	UL

<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>

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.