• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

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
0
searchsanjaysharma
Asked:
searchsanjaysharma
1 Solution
 
rspahitzCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now