• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Need Help From Excel Gurus

I don't think knowing how to compute an average in excel qualifies one as a guru...

That being said...

=AVERAGE(B14:M21)
 
Is this junior high or high school homework?

Not being sarcastic - with 2 posts, both on this topic, it looks like you're trying to get us to do your work for you.

[edit] Damn, you have an actual job in insurance... That makes me sad.
 
Last edited:
AreaCode707 said:
Is this junior high or high school homework?

Not being sarcastic - with 2 posts, both on this topic, it looks like you're trying to get us to do your work for you.
Click to expand...

Yup, and it took .7 seconds out of my otherwise boring life of useful excel tasks.

Though an assignment on average would have to be grade 5 or 6 no?
 
AreaCode707 said:
Is this junior high or high school homework?

Not being sarcastic - with 2 posts, both on this topic, it looks like you're trying to get us to do your work for you.
Click to expand...

Using words like swell and the obvious ease of the problem suggests 1950's junior high.
 
avg.jpg
 
AreaCode707 said:
Averaging the average of each row will give you a different result than taking an average of all the applicable data.
Click to expand...
Yes, but only in months that are not January 😉 (and only if one has excel set up to treats those blank spaces as 0)
 
Last edited:
Average from Jan 01-Dec 08: 5.3
Average of all data: 5.8
Average of the averages of each line: 5.9
Average of the averages of lines 01-08: 5.3
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top