| Next: Exmodulau.exe, Keeps Wanting To Access The Web |
| Author |
Message |
Gary66
Joined: Sep 01, 2005
Posts: 8353
|
 Posted: Thu Mar 16, 2006 5:48 am Post subject: |
|
|
|
| I could never get the hang of using formulas in Excel. You know know you can have column a + B +c =d I got that far but I was wanting like an average on a continuing basis. As each entry is made the total is rcalculated as well as the average. Any help would be great.
|
|
|
| Back to top |
|
 |
FormalDaHyde
Joined: Jan 02, 2005
Posts: 1511
|
| Posted: Thu Mar 16, 2006 2:53 pm Post subject: |
|
|
|
|
| Back to top |
|
|
mthompso
Joined: Dec 05, 2002
Posts: 557
|
| Posted: Thu Mar 16, 2006 9:34 pm Post subject: |
|
|
I recommend a healthy dose of F1.
Since Gary66 is an Excel newbie, I would recommend the MS Ofice help function. Do a search for "average" and "sum".
-Matt |
|
| Back to top |
|
|
FormalDaHyde
Joined: Jan 02, 2005
Posts: 1511
|
| Posted: Thu Mar 16, 2006 9:43 pm Post subject: |
|
|
Indeed!
Mastering the way to create FORMULAs can be a learning curve!
Search key word (via F1) "FORMULA" and practice how to create them!
Patience may be a virtue in this case as Excel is a very complex program!
Much more so than Word but not as bad as Access (database management). |
|
| Back to top |
|
|
Gary66
Joined: Sep 01, 2005
Posts: 8353
|
| Posted: Thu Mar 16, 2006 9:55 pm Post subject: |
|
|
| Quote: |
I recommend a healthy dose of F1.
Since Gary66 is an Excel newbie, I would recommend the MS Ofice help function. Do a search for "average" and "sum".
-Matt
|
I use Excel but not in that manner. Thanks I will give it a go. |
|
| Back to top |
|
|
zlim
Joined: Mar 11, 2005
Posts: 2378
|
| Posted: Fri Mar 17, 2006 2:02 pm Post subject: |
|
|
Gary, type your entries in column a, let's say 25 entries
In A26, type an = then select insert formula and choose sum
the entry will read SUM (A1:A25) click enter and the sum is instantaneous. If you change any or all of the 25 entries, the sum sell A26 will change without you doing anything.
Go to A27 and type = again and insert but this time select average.
You have to edit because it will want to find the average of A1:A26 NOT what you want; you want A1:A25 Again the average changes as soon as you alter any data in the first 25 cells.
You can skip cells and put titles in if you wish, just be sure that the field range contains the cells that have the data. |
|
| Back to top |
|
|
Gary66
Joined: Sep 01, 2005
Posts: 8353
|
| Posted: Fri Mar 17, 2006 7:16 pm Post subject: |
|
|
| Quote: |
Gary, type your entries in column a, let's say 25 entries
In A26, type an = then select insert formula and choose sum
the entry will read SUM (A1:A25) click enter and the sum is instantaneous. If you change any or all of the 25 entries, the sum sell A26 will change without you doing anything.
Go to A27 and type = again and insert but this time select average.
You have to edit because it will want to find the average of A1:A26 NOT what you want; you want A1:A25 Again the average changes as soon as you alter any data in the first 25 cells.
You can skip cells and put titles in if you wish, just be sure that the field range contains the cells that have the data.
|
Thanks Liz.
:thumbup: :thumbup: |
|
| Back to top |
|
|
|
General