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...
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.
