adding an "if" condition to indirect

I've recently added the IF(L12="","", part to my formula but if I move the contents in L12 the formula changes to the new location of L12.

How do I add "indirect" to the added part of the formula...so L12 stays put?

Thanks.

Bruce

formula: =IF(L12="","",SUM(INDIRECT("$l$12:l12")))

I tried adding the "$L$12" but if I move L12 to another location (say L7) the formula changes to L7.

note: the formula is located in P12.

I'm trying to have the formula in P12 always look at L12, even if I move L12.

When I first created the formula I had the same problem but after some help (from this forum) the "indirect" was added and that solved the moving issue.

Suggestions.

Bruce

I would think it would be a simple fix but I've tried everything I know of and I still can't get it to work.

Any additional suggestions?

Bruce

I used your formula (substituting L12 for Z1) and it still doesn't work.

I'll work on it in the morning.

Thanks.

Sorry for the late response.

The formula worked once I stopped over thinking it.

Thanks everyone for all your help.