MIN MAX AND AVERAGE - Excluding Zero value

[EleanorSykes1989]

Hi,

Wondering if anyone can help please. I need to find the min, average and max values from a column in excel.

However, I need to exclude any "0" values, and to save be changing the range I need to also find the average based on a set criteria.

So, like an average value in one column, but only if the factory name is "Derby"


Thanks

 

[Fluff]

How about

Book1
	A	B	C	D
2	Cumbria	3	Max	11
3	Derbyshire	4	Min	2
4	Derbyshire	0	Average	4.5
5	West Yorkshire	2
6	Derbyshire	3
7	West Yorkshire	0
8	Derbyshire	4
9	Staffordshire	5
10	Derbyshire	11
11	Derbyshire	0
12	Cheshire	6
13	Derbyshire	7
14	Greater Manchester	7
15	Derbyshire	7
Sheet2

Cell Formulas
Range	Formula
D2	=MAX(B2:B15)
D3	=AGGREGATE(15,6,B2:B15/(B2:B15>0),1)
D4	=AVERAGEIF(A2:A15,A3,B2:B15)