Originally Posted by
Domenic
Can you clarify the rules that need to be followed in calculating the average?
Ok, what I have is columns of numbers (maybe 20 or so) matched up to a name. The results are pulled from other worksheets via vlookup. The problem is that sometimes the results don't exist...and I want the average function to ignore that somehow, if possible.
As you can see in this example, he only had 2 results out of 7 sets, causing the TRIMEAN function to give the #NUM! error. It's not a huge problem, normally I just go and delete all the "#N/A"s when I'm ready to finalize my list, just seemed like maybe excel would have an easier way of handling that.
Bookmarks