LinkBack URL
About LinkBacks
How would I add to this formula to stop the #Div/0! when there are no entries. Normally I would use =IFERROR but using the average function as well is confusing me.
=AVERAGEIFS($C$12:$Z$12,$C$12:$Z$12,"<>0",$C$4:$Z$4,"<>sales")
Thanks
How would I add to this formula to stop the #Div/0! when there are no entries. Normally I would use =IFERROR but using the average function as well is confusing me.
=AVERAGEIFS($C$12:$Z$12,$C$12:$Z$12,"<>0",$C$4:$Z$4,"<>sales")
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks