I have a spreadsheet that I record data every day. In column A, I have (for
example) Mon, Tue, Wed, etc. Then in column H, I have recorded times (for
example) 16:20, 17:30, 15:00 etc. I want averages for (All Days), (Weekdays),
(Weekends) and (Tue, Wed, Thu). Right now I have a simple average formula set
up and each month I have to change the formula to fit the month because the
rows will change. How can I set this up so regardless of the month, the
formula will only look at whether or not it's a Mon, Tue, Wed, Thu, etc in
column A and average the time in column H for their respective days?
I hope I explained this well enough.
ANY help would be greatly appreciated
Thank you, Karen