LinkBack URL
About LinkBacks
I am looking to add into the average function to ignore #N/A values and average everything else.
=IF($A109>Key!$B$2,ERROR.TYPE(7),AVERAGE(BI98:BI109))
Thanks,
I am looking to add into the average function to ignore #N/A values and average everything else.
=IF($A109>Key!$B$2,ERROR.TYPE(7),AVERAGE(BI98:BI109))
Thanks,
Instead of that, have you considered adjusting teh formulas that result in NA?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
They need to be #N/A because it is data to be used in a graph and just an NA makes the graph wonky.
Try
=IF($A109>Key!$B$2,ERROR.TYPE(7),AVERAGEIF(BI98:BI109,"<>#N/A"))
Jonmo will ERROR.TYPE work in 2007?
Not sure about that that.
I was going on the assumtion that the formula worked as is, as long as there's no #N/A errors in the range..
OP profile saying 2007 is not always correct..
If not, you can just write NA() (or even #N/A) instead instead of Error.Type(7)
OK, sorry, I did not notice that had included that as their formula in post 1. One of these days, I will read entire posts lol
Originally Posted by FDibbins
The ERROR.TYPE function is available in all versions of Excel.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks