software

Columns A amp; 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?--
redneck joe
------------------------------------------------------------------------
redneck joe's Profile: www.excelforum.com/member.php...oamp;userid=32570
View this thread: www.excelforum.com/showthread...hreadid=526937
redneck joe Wrote:
gt; Columns A amp; G, rows 1-20.
gt;
gt; I need A1*G1, repeated through row twenty, then divided by another
gt; seperate cell.
gt;
gt; There's got to be a function for that, rather than repeating the basic
gt; 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.--
BenjieLop------------------------------------------------------------------------
BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=526937
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--
redneck joe
------------------------------------------------------------------------
redneck joe's Profile: www.excelforum.com/member.php...oamp;userid=32570
View this thread: www.excelforum.com/showthread...hreadid=526937
Try:

=SUMPRODUCT(A1:A20,G1:G20)/H1--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=526937
That returning a zero..
John James Wrote:
gt; Try:
gt;
gt; =SUMPRODUCT(A1:A20,G1:G20)/H1--
redneck joe------------------------------------------------------------------------
redneck joe's Profile: www.excelforum.com/member.php...oamp;userid=32570
View this thread: www.excelforum.com/showthread...hreadid=526937quot;redneck joequot; wrote:
gt; John James Wrote:
gt; gt; =SUMPRODUCT(A1:A20,G1:G20)/H1
gt;
gt; 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.


If you attach your cut-down file with your data and the formula, the
problem may be clearer.redneck joe Wrote:
gt; That returning a zero..--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=526937