Hi again guys,
I'm still working on my tracker spread sheet that some of you kindly helped with yesterday but I've got stuck again.
I have now populated all of the data into the cells using the 'Data Dump' tab but I now need to work out how to calculate averages for the individuals 'talk time' in the 'Overall' tab excluding the blanks (which are days when they were not in) and the '0.00%' cells which are for future dates that are yet to be input.
I've tried a few things myself and from looking around on this site (and some others) but none of the formulas work.
Bookmarks