Formula Help


New Member

I need some help with creating a formula.

Basically, I am counting up all the letters in a row (P, F, U, B, S) and then I want to minus from the calculation the count of (L) in the row … however, if L = or > zero, I want the cell to be 0 .

my current formula


this is a spreadsheet tracking different types of absences but also lates. And I just want the calculation to produce the total absence types and disregard the lates entirely.

Thank you!


New Member
Are you saying that if "L" doesn't appear in any cells across that row, that the result should be 0?

Does this do what you're looking for?



MrExcel MVP, Moderator
Hi & welcome to MrExcel
Not sure I understand the bit about L= or > zero, but this will count all the P,F,U,B & Ss
Last edited:

Some videos you may like

This Week's Hot Topics