Spent a few hours searching this online and was not able to find a good solutions. Did find one but it was specific to a range of cells based on text color.
The problem:
I need to sum a total of values based on a header that is bold, has multiple breaks in rows, and is inconsistent in terms of total number of rows and breaks.
Question:
Is there a way to create a dynamic range using a cell font type and a white space, move that range to column C, sum all the values in that column, return SUM value adjacent to bold text row.
Bookmarks