Average With Data Hidden NOT WORKING

[muhammad susanto]

hi all..

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]data1[/TD]
[TD]data2[/TD]
[TD]data3 (Hidden)[/TD]
[TD]data4[/TD]
[TD]data5[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]5[/TD]
[TD]20[/TD]
[TD]12[/TD]
[TD]15[/TD]
[/TR]
</tbody>[/TABLE]

how to use average formula with data hidden column..
i have use average or subtotal but not working.
i'm use ms office 2010..

how to figure out this? I want can work for 2 condition, visible column or in hidden column

 

[RasGhul]

Hi,

I'm not sure about hidden columns but you could use criteria to exclude?

Book1
	A	B	C	D	E
2	Exclude1	Exclude2
3	data4	data2
4
5	data1	data2	data3	data4	data5
6	10	5	20	12	15
7
8	averageifs
9	15
Sheet1

Cell Formulas
Range	Formula
A9	=AVERAGEIFS($A$6:$E$6,$A$5:$E$5,"<>"&A3,$A$5:$E$5,"<>"&$B$3)

 

[muhammad susanto]

thank RasGhul...
your formula that contains specific cell as criteria, it mean it manually..
i want the formula working similar like subtotal(109,......) function, just hidden or unhiden formula, the formula work properly