Averages from different ranges in excel.

Wanted to calculate averages in excel from different ranges:

On attachment I wanted to calculate two different percentages  (highlighted in red) and the average at the gray box in B46 which should be 91%
C--Users-lfreund-Desktop-AVERAGE.xlsx
LUIS FREUNDAsked:
Who is Participating?
 
NorieConnect With a Mentor VBA ExpertCommented:
Luis

I might be missing something but can't you use this simple formula for that.

=AVERAGE(B1,B31)
0
 
Ares KurkluConnect With a Mentor Software EngineerCommented:
Not sure but are you trying to do this?

=AVERAGE(B3:B28,B33:B44)
0
 
LUIS FREUNDAuthor Commented:
What the heck....I tried that initially and it didn't work....brain fart on my end!  Thanks guys for the help....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.