Excel: Dragging down a Indirect formula.


Hello, being a novel excel user I usually find my answers on this and other forums. This problem has stumped me I have tryed to write the formula many diffrent ways. All do not work as well as this one. I need to be able to have excel update my cell refrences when I drag this formula down. Any help will be appreciated, and I'm sorry if I have written this crudely. =SUM(SUMIF(INDIRECT({"AC12","AE12","AG12","AI12"}),">0")/4)


This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of May 10, 2015.


For more resources for Microsoft Excel