Average help please

[brotherh]

Hello, can anyone help with a formula to help with the following?
I use averages for stock control and simple divide annual usages by 12 to decide what I should keep but the averages can be incorrect due to one off large quantity uses.
Is there a way of looking all cells in the year and if 9 of them (or a chosen amount) are 0 an alert or true/false cell is added?
Or if there isn't usages across multiple cellsan alert or ture/false cell is added?

Unit jan feb mar apr may jun jul aug sep oct nov dec total Average
1 120 0 0 0 0 0 0 0 0 0 0 0 120 10
2 10 10 10 10 10 10 10 10 10 10 10 10 120 10

For unit 1 i'd like to ignore it and unit 2 i'd need to keep 10.

any help or suggestions would be greatly appreciated, thanks Arran.

[rcm]

Please Login or Register  to view this content.