HELP! In Excel

[thjplgvp]

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

 

[rsr]

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.)

 

[thjplgvp]

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

 

[James_Newman]

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

I always love it when someone uses excel to put together a spread sheet and they don't use formulas, they just use a calculator and plug the numbers in manually.:tongue3:

 

[rsr]

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 SUM command does indeed work beautifully, and it allows you to add lots of data without having to reset all the cells manually.

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.

 

[rsr]

I always love it when someone uses excel to put together a spread sheet and they don't use formulas, they just use a calculator and plug the numbers in manually.:tongue3:

At least the numbers look pretty ...