0")/4) Last edited by Chocolate_bar; Yesterday at 10:33 AM. .">
Most valuable professional
  • Hot Topics

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) Last edited by Chocolate_bar; Yesterday at 10:33 AM.

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel