I am trying to combine an Average Subtotal function, excluding blanks, with checking whether a dataset is complete
Columns B to T contains the data. Not every row is populated though (left blank) and within a row those inputs which are zero are also left blank
Column A is summing up columns B to T
What i am struggling to create is a Subtotal function for each column which gives me an average, but only for those rows where the data in column A equals to 100%, including the blanks (as zeros) for those rows were column A is 100%
Is this possible?
Bookmarks