I have a pretty complicated sheet that is calculating the average for the last 3 days, 6, 12 and 24 days. I have noticed that the answers fro 3 & 6 days are correct, but the 12 & 24 days are not correct.
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=AVERAGE(OFFSET(C1,0,COUNT(C2:ZY2)-3,16,3)) is correct answer!
[/FONT][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=AVERAGE(OFFSET(C1,0,COUNT(C2:ZY2)-6,16,6))<strike></strike>
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=AVERAGE(OFFSET(C1,0,COUNT(C2:ZY2)-3,16,3)) is correct answer!
[/FONT][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=AVERAGE(OFFSET(C1,0,COUNT(C2:ZY2)-6,16,6))
is correct answer!
These are not correct
[/FONT]<strike></strike>These are not correct
=AVERAGE(OFFSET(C1,0,COUNT(C2:ZY2)-12,16,12))
=AVERAGE(OFFSET(C1,0,COUNT(C2:ZY2)-24,16,24))
the formula only counts cells with numbers in them. I have checked and there are no zeros, the formatting is for numbers. I am stumped as to why this is happening. Any help would be appreciated
the formula only counts cells with numbers in them. I have checked and there are no zeros, the formatting is for numbers. I am stumped as to why this is happening. Any help would be appreciated