How to calculate Total from 2 columns with character value.

How to add two columns in such a value that reference error doesnt come.

The sheet is attached.
sample-data-1.xlsx
searchsanjaysharmaAsked:
Who is Participating?
 
rspahitzConnect With a Mentor Commented:
You could try a formula like this:

=IF(AND(ISNUMBER(D2),ISNUMBER(E2)),D2+E2,"non-#")

Open in new window

0
 
searchsanjaysharmaAuthor Commented:
tx
0
All Courses

From novice to tech pro — start learning today.