Good Afternoon
I have a sheet with data that gets filled in via a Vlookup, one of the rows returns back results in the time format and I have a calculation cell at the end of the month that provides an Average of all the results.
However there is an option to blank out the data with a variety of options if they are carrying out a task which would affect the daily stats, When they blank out the stats my average formula is not working so I wanted to know if there’s any way I can bypass the fields with text in and purely look at the cells with a time figure in it.
Bookmarks