Dynamic Cells
 

I want to evaluate a single row at a time in a set of formulas.

How would I take a simple equation like =D6 + D12 and make the 12 in D12
dynamic?

Example =D6 + D&(C3) when C3 = 12


What would be the correct syntax to do this?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200902/1

Dynamic Cells
 

On Feb 13, 6:46*pm, "mmartens12 via OfficeKB.com" <u24614@uwe wrote:
I want to evaluate a single row at a time in a set of formulas.

How would I take a simple equation like =D6 + D12 and make the 12 in D12
dynamic?

Example * =D6 + D&(C3) * *when C3 = 12

What would be the correct syntax to do this?

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200902/1

=SUM(INDIRECT(D6&":D"&C12))

Dynamic Cells
 

One way:

=D6+INDEX(D:D,C3)

If C3 is an empty cell you'll get an error.

--
Biff
Microsoft Excel MVP


"mmartens12 via OfficeKB.com" <u24614@uwe wrote in message
news:91ac03228b8fe@uwe...
I want to evaluate a single row at a time in a set of formulas.

How would I take a simple equation like =D6 + D12 and make the 12 in D12
dynamic?

Example =D6 + D&(C3) when C3 = 12


What would be the correct syntax to do this?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200902/1

Dynamic Cells
 

Hi,

Here are two other solutions:

=D6+INDIRECT("D"&C3)

=D6+OFFSET(D1,C3-1,)

And for a little bit of interest if anyone reads this

=SUM(SUM(INDIRECT("D"&{6,12})))

note that the last formula will not return the correct result with only one
SUM, nor if it is array entered with one sum.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"mmartens12 via OfficeKB.com" wrote:

I want to evaluate a single row at a time in a set of formulas.

How would I take a simple equation like =D6 + D12 and make the 12 in D12
dynamic?

Example =D6 + D&(C3) when C3 = 12


What would be the correct syntax to do this?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200902/1

Dynamic Cells
 

Thank You!

T. Valko wrote:
One way:

=D6+INDEX(D:D,C3)

If C3 is an empty cell you'll get an error.

I want to evaluate a single row at a time in a set of formulas.

[quoted text clipped - 4 lines]

What would be the correct syntax to do this?

--
Message posted via http://www.officekb.com

Dynamic Cells
 

You're welcome!

--
Biff
Microsoft Excel MVP


"mmartens12 via OfficeKB.com" <u24614@uwe wrote in message
news:91cf07c2c0ce3@uwe...
Thank You!

T. Valko wrote:
One way:

=D6+INDEX(D:D,C3)

If C3 is an empty cell you'll get an error.

I want to evaluate a single row at a time in a set of formulas.

[quoted text clipped - 4 lines]

What would be the correct syntax to do this?

--
Message posted via http://www.officekb.com