Chocolate_bar
New Member
- Joined
- May 9, 2015
- Messages
- 10
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: