Average excluding negative values

[tangomj]

I have a range: B2:B700 with both positive and negative values.

How can I calculate the basic AVERAGE, MIN, MAX, and SUM while "excluding" all negative values within the range?

Thanks!

[BigBas]

=AVERAGE(IF(B2:B700>0,B2:B700))

Confirm with CTRL+SHIFt+ENTER, not just enter

Subsitute MIN/MAx for average when necessary

[tangomj]

Thanks. That worked great.

2nd part. In addition to the above. I also want to exlcude all values greater than 1095. Will this be a nested IF statement?

Avg IF X: 0 < X < 1095

[BigBas]

Try this and let me know:

=AVERAGE(IF((B2:B700>0)*(B2:B700<1095),B2:B700))

[tangomj]

Again thanks. That worked too.

[BigBas]

Glad I could help.