Forum Discussion

aleksihurme's avatar
aleksihurme
Copper Contributor
Nov 13, 2019

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 that i need to count AVERAGE from red box to yellow box. The problem is that sum counts blank spaces as 0. And that affects the AVERAGE. 

 

 

 

 

excel

3 Replies

    • aleksihurme's avatar
      aleksihurme
      Copper Contributor
      Nov 13, 2019

      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. 

Resources