Solved

How to calculate Total from 2 columns with character value.

Posted on 2013-06-07
2
173 Views
Last Modified: 2013-06-23
How to add two columns in such a value that reference error doesnt come.

The sheet is attached.
sample-data-1.xlsx
0
Comment
Question by:searchsanjaysharma
2 Comments
 
LVL 22

Accepted Solution

by:
rspahitz earned 500 total points
ID: 39229399
You could try a formula like this:

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

Open in new window

0
 

Author Closing Comment

by:searchsanjaysharma
ID: 39269001
tx
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question