You didnt understand me.. I put all that cells (B5,D5,F5H5,J5,L5,N5) just to clear the point... they are not supposed to be there ...Originally posted by Un4gIvEn1
Ok... I am not sure if I understand what you are trying to do, but here goes...
The value in A4 is incorrect, right? You are wanting that value to be the average of the totals of all of the days, right? You do not want to average the individual tallies for each day, only the total for each day. I would use =AVERAGE(B5:N5)
Hope that does it for you!
Edit: That formula returns a value of 13 BTW...
That is what I was searching... thank you...Originally posted by GoNz0
is this what your on about, all totals for all 7 days divide 7 = 13
=SUM(B3:N4)/7
i made the formula up for you here.
Thank You, I Just didn't understand before the matematical issue before....Originally posted by Enyo
LMAO. Nice GoNz0, very nice indeed
luish, good to see you solved it.