Skip to Content
0
Former Member
May 26, 2009 at 02:47 PM

Trying to remove 0's from Average summary

31 Views

I am trying to get an average of employee expenses. Some of the lines have a 0 amount. When I use the Summary function the 0 lines are included in the average. How do I exclude these? Example:

0

100

0

0

0

100

0

0

Average is 25 with the 0 lines. The average should be 100.

Thanks,

Rick