How to use Sum function in a way that it doesn't count 0? Excel 2016

[aleksihurme]

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. 

[#2]

@aleksihurme 

SUM() counts nothing, it only sums. To exclude blanks from average you may use AVERAGEIF().

[#3]

HI @Sergei Baklan 

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. 

[#4]

@aleksihurme 

You may exclude blanks with

=AVERAGEIF(A1:A100,"<>")