I have a sheet where I need to average the scores on the last column of data.
There are multiple rows with data in them, and some data will be missing in some of the cells, but the row will still tally the results in the last column.
Two specific cells in each row contains either a 0 or a positive number. If both cells contain a 0, then it is the end of the rows, and the row count used in the average needs to end there.
So, I just need to look for those two cells, and if they both contain a zero, take the last cell in the row above, and average it an all the values above it.
How can I go about doing this?
Bookmarks