One way to solve this problem is with the SUMPRODUCT function, as seen in the worksheet above.
Another approach is to use the newer BYROW function.
Both methods are described below.
Notice we are excluding column B which contains times.
This formula will return TRUE only when all cells in a given row are empty.
The result from SUM is then compared to zero to force a TRUE or FALSE result.
These results spill into the range J5:J16.
For example, it’s possible for you to use BYROW inside theFILTER functionto remove blank rows.
BYROW can apply stock functions like SUM, COUNT, and AVERAGE or a custom LAMBDA function.
