im looking to average the amount of calls we receive based on what day the calls were made.
Attached is a copy of the table i am using.
im looking to add up all the calls we received on a Monday and then average it for the amount of Mondays we have collected the data.
if i haven't explained this well im sorry just reply and i will hopefully be able to explain it better
P.S. i know this could be done by manually selecting the cells and then averaging them however this would be unsuitable as the data range is going to keep growing