I feel like an idiot this morning / afternoon. I want to add 3 numbers take their total and divide it by a set number for an average.
Hypothetically let us say the numbers are 500, 1234, 3600 and I want to divide these numbers by 82
Cell 1 =500 Cell 2 =1234 and Cell 3 = 3600 this total divided by 82 total to show up Cell 6
Culd someone submit the formula before I try to beat the answer out of my computer? :BangHead:
Thjplgvp
HELP! In Excel
Discussion in 'Computers & Technology Forum' started by thjplgvp, Oct 27, 2006.
-
Cell 6=(Cell1+Cell2+Cell4)/82
Or, depending on how the numbers are laid out: A4= (A1+A2+A3)/82
(There are simpler ways to do this to allow insertion of additional numbers -- using the SUM function -- but this general formula should work.) -
RSR
Thank you so much. I was trying to put sum, avg, etc in front of the formula and that is where I was goofing.
Thjplgvp -
-
The example for the case listed above is: =SUM(A1:A3)/82
If you insert additional numbers into the column, you can just adjust the parameters for the series - a1:a3, for example, to a1:a60 - without having to manually enter all the additional cells into the formula. -