Count occurrence if the any of the next columns have blank

manish4993395 

This last change came as a bit of a surprise!  Up to there my solutions were the same as HansVogelaar and JosWoolley.  To count occurrences I changed the formula to

Worksheet formula
= BYROW(table, CountBeforeλ("Shopping", "NULL"))

CountBeforeλ
= LAMBDA(countString, untilString, LAMBDA(line,
    LET(
        end,     XMATCH(untilString, line, , -1),
        matches, TAKE(line, , end) = countString,
        IFERROR(SUM(SIGN(matches)), 0)
    )
  ))