Average formula issue

[raghavsurya]

Hi All,

We have situation where in we need to ignore any negetive / zero values in the table and calculate the average or Min or Max values. For Example

Product	Profit
a	10
b	-4
c	6
d	8
e	0

The Average formula should ignore product b and product e which calculating average. Can anybody suggest how to do this.

Regards,

Raghav

[#2]

For example:

AVG(IF(Profit>0,Profit))

[raghavsurya]

Hi,

In the same scenario, if we want to select minimum of the values how should we put the formula. Can you please help us.

Regards,

Raghav

[#4]

Just change the AVG function to MIN.