What formula should I use to get an average of a group of averages. I have data that averages daily data by the day (say data collected on Monday); then data averaged each day of the weel (Tuesday's data, then Wednesdays data, etc. etc. for each day of the week. Now I want to AVERAGE the averages collected for each day of the week to arrive at a WEEKLY average.,. but I can only get a error in the final weekly average cell. This is the formula I jave been ising: =AVERAGEIF(N121:T121,"<>0") What am I doing wrong?
Solved by F. S. in 30 mins