Forum Discussion
How to use Sum function in a way that it doesn't count 0? Excel 2016
Hi, First off all, sorry English in not my first language. I need to make an excel that counts SUM first and AVERAGE after that. So i need to count SUM from blue box to red box. after t...
SUM() counts nothing, it only sums. To exclude blanks from average you may use AVERAGEIF().
HI SergeiBaklan
Thank you for your quick response. So we are counting average for a month. Somedays the real value is 0. So we need to count it also. But from weekend we don't gather data. So weekends and holidays needs to be blank.