Forum Discussion
Solved
Sum all cells with text EXCEPT with letter "D"
Calculating the M column for hours worked, I have a formula that will sum all amounts in cells in columns B:K with text to subtract them from the L column. Hours that remain are shown as hours worked...
=[@[Scheduled Hours]]-SUM(IFERROR(--IF(LEFT(Table27[@[M1]:[F2]])<>"D",MID(Table27[@[M1]:[F2]],2,99)),0))
=[@[Scheduled Hours]]-SUM(IFERROR(--IF(LEFT(Table27[@[M1]:[F2]])<>"D",MID(Table27[@[M1]:[F2]],2,99)),0))
Thank you! I was entering the <>"D" but it wasn't working and I knew I was missing a piece.