Counting cells with different values

[t2true]

Spreadsheet lists used and unused ports. Unused ports are identified with a “p”. Used ports show the port number:

P

p

3​

p

p

p

7​

8​

9​

p

p

p

p

p

15​

p

p

p

p

p

p

p

23​

p

p

p

3​

4​

p

6​

p

p

p

p

p

p

p

p

p

p

p

p

p

p

p

p

23​

p

p

p

p

p

p

p

p

p

9​

p

p

12​

p

p

p

p

p

p

19​

p

21​

22​

p

p

p

p

3​

p

p

6​

7​

p

9​

10​

p

12​

13​

14​

15​

16​

p

18​

p

20​

p

22​

p

24​

1​

2​

3​

4​

p

6​

7​

p

9​

p

p

p

13​

p

15​

p

17​

18​

p

20​

21​

22​

p

24​

p

2​

3​

4​

p

6​

7​

p

9​

p

p

12​

13​

p

p

p

p

18​

19​

20​

u

22​

23​

p

1​

p

p

p

p

6​

p

8​

9​

p

11​

12​

13​

p

15​

p

17​

p

19​

20​

21​

p

p

24​

p

p

p

4​

p

p

p

p

p

p

11​

12​

13​

p

15​

16​

17​

p

19​

20​

p

p

p

24​

p

2​

p

4​

5​

p

7​

8​

p

p

p

p

p

p

p

16​

p

p

p

20​

p

p

23​

p

p

p

p

p

p

p

p

p

p

p

p

p

p

p

p

p

p

p

p

p

p

p

p

p

At the end of each row needs to show total for used and unused. I am using =COUNTIF(A1:A24,"p") to find unused. But, I do not know how to find used ports since the value in each cell is different. Maybe a formula to count cells that do not have “p”?



Thank you

 

[arthurbr]

Perhaps =COUNTIF(A1:A24,"<>p")

 

[JoeMo]

From your formula, it appears you want to show totals for each column, not each row. In that case maybe'

=COUNTA(A1:A24)- COUNTIF(A1:A24,"p")

for used ports.
EDIT: Note that this formula excludes counting any blank cells in the column.

 

[Fluff]

Do you mean at the end of each column?
If so try
=COUNTIF(A1:A24,"<>p")

 

[t2true]

Yes. Adding the <> did the trick. Thank you all for your help.

 

[Fluff]

Glad we could help & thanks for the feedback.