Appreciate for any help on how to trick this code to overlook error value when scroll down,
it does return the correct result when code is typed in, but when scroll down return #VALUE,
tried different things with if is error but no luck so far....
Thanks in advance for any advice..!!
Please Login or Register to view this content.
no sample sheet provided, so a WILD guess:
=iferror((SUMIF($H$12:$H$69,B15,$K$12:$K$69)+SUMIF($O$12:$O$69,B15,$R$12:$R$69)+SUMIF($V$12:$V$63,B15,$Y$12:$Y$63)+SUMIF($AC$12:$AC$70,B15,$AF$12:$AF$70))/(COUNTIFS($H$12:$H$69,B15,$H$12:$H$69,B15)+COUNTIFS($O$12:$O$69,B15,$O$12:$O$69,B15)+COUNTIFS($V$12:$V$63,B15,V12:$V$63,B15)+COUNTIFS($AC$12:$AC$70,B15,$AC$12:$AC$70,B15)),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
Did you try this?
=IFERROR(SUMIF($H$12:$H$69,B15,$K$12:$K$69)+SUMIF($O$12:$O$69,B15,$R$12:$R$69)+SUMIF($V$12:$V$63,B15,$Y$12:$Y$63)+SUMIF($AC$12:$AC$70,B15,$AF$12:$AF$70))/(COUNTIFS($H$12:$H$69,B15,$H$12:$H$69,B15)+COUNTIFS($O$12:$O$69,B15,$O$12:$O$69,B15)+COUNTIFS($V$12:$V$63,B15,V12:$V$63,B15)+COUNTIFS($AC$12:$AC$70,B15,$AC$12:$AC$70,B15),"")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for your replay Glenn Kennedy, not exactly what I looking for, this return a blank if there is an error,
there is empty cells and text along the code range... trying to trick the formula to overlook these errors and get the desire result
Thanks AliGW, yes I did... not exactly what I looking for, this return a blank if there is an error,
there is empty cells and text along the code range... trying to trick the formula to overlook these errors and get the desire result
Solved, Credit to Piet200
Please Login or Register to view this content.
Who is Piet200???
Some other forum contributor who had a sample file posted for someone else asking help for the same ...
OK - it would be helpful if you would post a link in this thread to the other thread where this similar question was asked, please. Thanks.
AliGW, do not have link by now... will do next time...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks