Spreadsheet lists used and unused ports. Unused ports are identified with a “p”. Used ports show the port number:
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
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