Formula Help - Can't get excel to calculate properly

  • Thread starter Thread starter it''''''''sh hardy
  • Start date Start date
I

it''''''''sh hardy

So i have a formula that I need help with - big surprise lol!

Let's say I have the following info:

10
5
5
50
400

I need to get the average per sale from the 400 coming from the 50 total
sales - but need the two 5 sales out, although they need to remain in the
tracker! I'm sure it's possible, but if I can get some assistance that would
be fantastic!

Thanks
 
=AVERAGE(IF(A1:A5=5,"",A1:A5))

NOTE: thei si an array formula that must be entered with CNTRL-SHFT-ENTER
rather than just the ENTER key.
 
Back
Top