I LOVE YOU TYRO. It worked beautiful except I may not have been clear on the
averaging part. Say my total for Col D is 83 and My total for Col E is
289.3367(these are examples of actual figures I am working with). Then I
want to divide Col E by Col D and come up with a figure like 2.0489. You
explained it all so easily for me. I am the forms queen where I am, but have
never tackled formulas. I really need to learn. Thank you.

"Tyro" wrote:

Assuming your table occupies cells B1 through E44
Then in cell E1 put the formula =C1*D1 and drag that down thru E44
I'm unclear as to exactly what you want done now. But this may help:
To average column D in D45 put the formula =AVERAGE(D1:D44)
To sum column D in D45 put the formula =SUM(D1:D44)
To sum column E in E45 put the formula =SUM(E1:E44)
To average the sums in F45 put =(D45+E45)/2

"Carla" wrote in message
...
I have a very simple table that I would love to insert a number that will
multiply the current number then average the whole table. I am sure it is
simple, just a bit beyond me. The table has Col B with letters Col C are
the numbers that correspond Col D I would like to put in my own and Col E
I
would like the answer of C and D multiplied. There are 44 rows total that
I
would then like to average the total number put in Col D with the total
sum
of Col E. If someone could do it for me It would be great I could email
the
Table.
EXample of Info in columns B-RMA C-2.0480 D-? E-C times D
This would repeat 44 times. Then add D and E and average.