Assume I want to average the contents of A1, C1 and E1 and ignore B1 and D1
And A1,C1 or E1 could contain a #N/A error. Various IF statements work fine if the rage of cells to average is continuous but I am stumped on what too do with non-adjacent cells!
Do you have more than 3 cells to average?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Nope, 3 will do it!
Try this...
=IFERROR(AVERAGE(IF(ISNUMBER(A1),A1,{""}),IF(ISNUMBER(C1),C1,{""}),IF(ISNUMBER(E1),E1,{""})),"")
Yes that works for me! Thank you too much!
You're welcome. Thanks for the feedback!
NP... I posted another one if you think you might be able to help!
http://www.excelforum.com/excel-form...umproduct.html
I'm getting ready to call it a day. I'll take a look at it tomorrow.
Not a problem! Thanks for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks