got to be an easier way?

[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?

 

[BenjieLop]

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?

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.

 

[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

 

[John James]

Try:

=SUMPRODUCT(A1:A20,G1:G20)/H1

 

[redneck joe]

That returning a zero..

Try:

=SUMPRODUCT(A1:A20,G1:G20)/H1

 

[Guest]

That returning a zero..

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.

 

[John James]

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