Hey guys, I'm having an issue with making my averageifs ignore blanks, i tried using "=0", "= ","=""" etc...
=AVERAGEIFS($G17:$NG17;$G$12:$NG$12;"=1";$G17:$NG17;"<>0")
Plus I can't replace my "=1" with a cell to =A26 because I get a formula error, any suggestions?
Is this solved?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
I can't find how to delete the topic, I was just dumb not to realise, that the cells I was averaging in the sample were all blanks...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks