What will be your formula if you are going to get the average of the - ProProfs Discuss
Advertisement

What will be your formula if you are going to get the average of the cells: A1=90 A2=85 A3=80 A4=75 A5=75?

Asked by Lorie, Last updated: Apr 10, 2024

+ Answer
Request
Question menu
Vote up Vote down

3 Answers

hornb025

hornb

hornb025
Hornb

Answered Mar 04, 2020

= average (A1: A5).

upvote downvote
Reply 

M. Klose

M. Klose

M. Klose
M. Klose, Content Writer, Oakland

Answered Jan 04, 2019

In an excel spreadsheet, many people get tired of having to calculate the costs of items to get an average. Instead of inputting everything, the person can type in a formula for a range of cells and have the computer program calculate the amount for each cell.

If you want to get the average of the cells for A1 through A5, you can put it into a formula. For instance, if A1 is 90, A2 is 85, A3 is 80, A4 is 75 and A5 is 75, then you would type into the cell an equal sign and the word average.

Then you need to put in the cells, so you would type A1 colon and then A5 to show that you want the average of these cells together.

upvote downvote
Reply 

lorie

lorie

lorie
Lorie

Answered Sep 29, 2018

=AVERAGE(A1:A5), =(A1+A2+A3+A4+A5)/5, =average(a1:a5), =(a1+a2+a3+a4+a5)/5
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.