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