My sub-totals are not adding columns that have empty cells or error values formatted to display 0. How do I format the sub-totals to treat these cells as 0?
This is a small portion of the file. I can't attach the entire file, but if you need to see the formatting I could try to duplicate in a smaller version. As you can see below, the sub-total of L1 does not appear because (I think) there are empty cells in the column. I can't remove the rows because there are values in other columns. The sub-total of L2 sums the rows in the category correctly.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.