View Single Post
  #1   Report Post  
Vinaya
 
Posts: n/a
Default Help with Formula

Hi,

I need to calculate average of 3 months. However, if any particular
month is defying the normal trend, that month should be ignored while
calculating the average.

For Eg:

Jan Feb Mar Average
2 2 2 2
4 4 6 4
2 1 2 2


Is this possible?

Regards,
Vinaya.