In MS-Excel which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell

Comments and Answers (2)

Andrew

Andrew

please anyone explain this answer

Zoe

Zoe

please explain answer

Avatar

{{SampleComment.userName || "Your Name"}} ~ {{SampleComment.userCity}}

{{SampleComment.commentValue || "Your Answer or Comment goes here...."}}