I want to calculate the averages of a number of values in a range that conform to different criteria (with the answers in seperate cells). Here's what I mean:
Column A (Cells A1-A150) contains values for profit/loss transations. I want to calculate the average profit (value >0.00) and average loss value <0.00) seperately in two different cells (B1 & C1).
Please advise how I can use the VLOOKUP/IF functions to do so as I'm not sure on the syntax needed. I know how to do a comparison cell to cell e,g, IF(VLOOKUP(A1<0.00,,,),,) etc but not sure how I do the lookup to say check any value in the named range to see if it's <0 etc.
Thanks!
Bookmarks