Formula Help - Can't get excel to calculate properly

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
 
G

Gary''s Student

=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Averaging Formula 8
Formula not working properly 2
Formula to calculate commission based on sliding scale 2
Help calculating scaled commissions please 5
*** HeLp with Array formula 4
Counting Formula 5
Calculated Fields in Pivot Tables using Existing aggregates 0
if conditional formula required 13

Top