I wan to Multiply a number in a cell I call A1 by .00029 and its answer in A4
.. Then be able to add up the entire A column in A6.
--
Sincerely,

Biz Broker

Your Business has the POWER of our Business

I wan to Multiply a number in a cell I call A1 by .00029 and its answer
in A4
.. Then be able to add up the entire A column in A6.

in A4 =a1*0.00029
in A6 =sum(A:A)


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=509261

I wan to Multiply a number in a cell I call A1 by .00029 and its answer
in A4
.. Then be able to add up the entire A column in A6.

in A4 =a1*0.00029
in A6 =sum(A:A)

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=509261

That won't work because the sum of the whole column includes the sum
itself thus creating a circular reference i.e. when adding up all cells
from A4 down Excel wants to add the contents of A6 but it hasn't
calculated that contents yet.

The problem as you describe it seems to be a bit confusing. If you have
a value just in A4 why would you want to sum up the whole column?

If you are a bit more specific as to what you are trying to do we might
be able to suggesst a solution.

Hans

Dav,

I actually set it up this way =SUM(C18*0.00029)
A Column B Column
Loan Amount $522,000
Payment at Full Interest Rate: $3,489
Other Mortgages: $0
Insurance/month (.0029*Value) $151
Taxes/month (.001*Price) $522
Total CC Debt (Total*.05): $0
Total Vehicle Debt: $0 $0
Vehicle Payments/month: $0
Other Loans: $0
Payments/month: $0
Total Payments (Debt) $4,162

and it worked this way. But I will keep your equation as well. Forgot the
astrick represented multiplication.
--
Sincerely,

Biz Broker

Your Business has the POWER of our Business


"Dav" wrote:


I wan to Multiply a number in a cell I call A1 by .00029 and its answer
in A4
.. Then be able to add up the entire A column in A6.

in A4 =a1*0.00029
in A6 =sum(A:A)

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=509261