Solve Sum Error In Excel

How to solve Sum Error in excel.

Music: Cuba
Musician: ASHUTOSH

[calvinlong]

The Sum() ignores the error cell in office 365

[zwnodps]

can u explain to me how to calculate in kwh ? i already try the =SUM( then it show me 0 instead pls help me how to calculate in kwh

[waynetrieu]

Hi I hope you can help me with this calculation. I want to calculate average all of sum results (same date, different values)

[milkdaddy]

does this not apply if some cells were blank?

at first I used =sum (cell address:cell address)
mine would result to
if I used sumif it would result to -
even though some cells does have some digits on it
please help