This will give you what you need...
=AVERAGEIF(E3:E10,"<>N/A",E3:E10)
For future reference, please include your question IN your thread, not your file. That way, members dont need to openthe file to see if they want to take up your question
This will give you what you need...
=AVERAGEIF(E3:E10,"<>N/A",E3:E10)
For future reference, please include your question IN your thread, not your file. That way, members dont need to openthe file to see if they want to take up your question
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks