hi community

when I use the Sum() to add a range and within the range of cells there is 1
cell that has Text data
and
the output of the Sum() function does not display the #value! error
however
when I used the "=" and added up all the cells
the output display the #value! error
can someone kindly enlighten me on this?

thanks community

:)
--
oldLearner57