Finding average win and loss

[hollacost69]

I have 12 columns of numbers. I am trying to find the average profit/losses for each column. The average loss in column A should be "-$102.50". Average win in Column A should be "$504.29". Thank you.

[jeffreybrown]

A13 =averageif(a1:a11,">0")
A14 =averageif(a1:a11,"<0")

[hollacost69]

Thank you sir!

[jeffreybrown]

You are very welcome. Thank you for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.