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))