| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help - Can't get excel to calculate properly
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help - Can't get excel to calculate properly
=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. -- Gary''s Student - gsnu201001 "it''''''''sh hardy" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula not working properly | Excel Worksheet Functions | |||
| The formula does not calculate properly... Help me if you could.. | Excel Worksheet Functions | |||
| Excel should calculate exponentials properly (right to left) | Excel Worksheet Functions | |||
| Sum formula is not adding up properly | Excel Discussion (Misc queries) | |||
| How to calculate/properly display significant figures ending in 0 | Excel Worksheet Functions | |||
Linear Mode
