Calculating Average

T

Thomas Emmanuel Datong

New Member
Joined
Oct 13, 2022
Messages
1
Office Version
  1. 2003 or older
Platform
  1. Windows
Cell A1 has 30
Cell C1 has -
Cell E1 has 50
How do I calculate in cell C10 the average of the three cells using either sumifs/countifs or a better way-out please
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

M
  • Question Question
Formula to calculate how much to add or subtract to keep totals even
Replies
7
Views
172
MrHoyt
M
C
  • Solved
Batch Print
Replies
8
Views
107
csmithbuffalo
C
K
  • Question Question
Averageif of cells from three sheets
Replies
7
Views
298
Fluff
Fluff
J
  • Question Question
Conditional Formatting with deleting rows
Replies
1
Views
380
6StringJazzer
6StringJazzer
O
  • Solved
Contribution to an overall % growth (Math Question)
Replies
2
Views
68
onthegreen03
O

Forum statistics

Threads
1,223,927
Messages
6,175,444
Members
452,642
Latest member
acarrigan

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top