Average before whilst filtering .

[Sunline]

Hello all ,

I wanting to get the results I havr in col E .

They are simply averaging col B .

Result in cell E11 comes from averaging cells B2:B10
Result in cell E10 comes from averaging cells B2:B9
Result in cell E9 comes from averaging cells B2:B8 and so on .

Also I need to filter three or four cols and am needing to average only those cells
that are filtered .

Thanks .

Excel Workbook
	B	E
1	Dlst	WDlst%
2	10	0
3	15	10
4	175	12.5
5	20	66.6
6	15	55
7	17	47
8	49	42
9	175	43
10	29	59.5
11	31	56.1
Sheet1

 

[FDibbins]

Try this...
=AVERAGE($B$2:B2)
copied down

 

[AhoyNC]

If you only want to average filtered cells try:

=SUBTOTAL(1,$B$2:B2)

<colgroup><col width="172"></colgroup><tbody>
</tbody>

 

[FDibbins]

If you only want to average filtered cells try:

=SUBTOTAL(1,$B$2:B2)

<colgroup><col width="172"></colgroup><tbody>
</tbody>

oops missed the "need to filter" part, apologies

 

[Sunline]

Thanks for those , but the functions don’t match my results .

For example average cells B2:B10 , result is 56.1 but I need it to go into cell
E11 . Then if I was to filter say 2 x cols it would only average what I filtered

Thanks .

 

[AhoyNC]

Should work if you start the formula in cell E3.

Excel Workbook
	A	B	C	D	E
1		Dlst			WDlst%
2		10			0
3		15			10
4		175			12.5
5		20			66.66667
6		15			55
7		17			47
8		49			42
9		175			43
10		29			59.5
11		31			56.11111
Sheet

 

[Sunline]

Great thanks