I am using a Mac
I have a work book, 2 sheets - 1st sheet contains columns with dates (full year) , rows are 1/2 time slots and in those time slots are whole numbers
I am trying to do a formula that will calculate and ongoing average for the last 3 months (workdays only) to put onto sheet 2
What I have done (and was going to just manually change every month) is:
=AVERAGE(IF(WEEKDAY('Sheet1'!$B$2:'Sheet1'!$NC$2,2)<6,'Sheet1'!$B4:'Sheet1'!$NC4))
But the average number is not coming up correctly it's reading 0.5 instead of 3.1 (as it should)
I have no idea what I'm doing wrong and I can't find an answer on google that is what I need
Bookmarks