got to be an easier way?

R

redneck joe

Columns A & G, rows 1-20.

I need A1*G1, repeated through row twenty, then divided by another
seperate cell.

There's got to be a function for that, rather than repeating the basic
math 20times?
 
B

BenjieLop

redneck said:
Columns A & G, rows 1-20.

I need A1*G1, repeated through row twenty, then divided by another
seperate cell.

There's got to be a function for that, rather than repeating the basic
math 20times?
Click to expand...


ASSUME that your divisor, located in another cell, is in Cell H1, then
your formula is

=A1*G1/$H$1

and copy down until the 20th row.

Regards.
 
R

redneck joe

Thanks, but....

I'm never clear enough.

This needs to take place in one cell, not over the column.

(A1*G1)+(A2*G2)+(repeat through 20)/H1
 
J

joeu2004

redneck joe said:
That returning a zero..
Click to expand...

But that seems to be the right answer for what you said
you wanted ((A1*G1 +...+ A20*G20)/H1). What makes
you think zero is the wrong answer?

Try just =SUMPRODUCT(...) to see if it is truly zero.
Try formatting the cell as Scientific with 14 decimal places.
 
J

John James

If you attach your cut-down file with your data and the formula, th
problem may be clearer.
 
Top