Dragging down a Indirect formula.

[Chocolate_bar]

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)

 

[gaz_chops]

Sorry, I still don't understand.

What in your last example, tells us that "no other data would be entered"?
Surely for it to be 100% the 2 86%'s and the 0% should be 100%?

There are obviously other factors we are not aware of, I'll take a guess that the Numbers 19, 9, 9 are number of procedures required to hit 100%!
Therefore in last example, the 1st 0% should be ignored! The divisor in that case would be 3 not 4, giving a result of 95%, am I close?

Gaz

 

[FormR]

Probably missing something here - but isn't it a simple average..

Excel 2012
	AB	AC	AD	AE	AF	AG	AH	AI	AJ
12	2	100%							100%
13		0%	19	112%	9	86%	9	86%	71%
14	8/8	100%	3/4	75%	1/2	50%	8/8	100%	81%
Sheet1

Cell Formulas
Range	Formula
AJ12	=AVERAGE(AC12,AE12,AG12,AI12)

 

[gaz_chops]

Probably missing something here - but isn't it a simple average..

Excel 2012

	AB	AC	AD	AE	AF	AG	AH	AI	AJ
12	2	100%							100%
13		0%	19	112%	9	86%	9	86%	71%
14	8/8	100%	3/4	75%	1/2	50%	8/8	100%	81%

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula AJ12 =AVERAGE(AC12,AE12,AG12,AI12) <tbody> </tbody>

<tbody>
</tbody>

Not sure, I think it's based on whether or not there are values in AB, AD etc

So maybe
=SUM(AC12,AE12,AG12,AI12)/COUNTA(AB12,AD12,AF12,AH12)