How can I total just the numbers in a column and ignore non-numeric strings?

B

Bud

I have a column of prices as shown and want to be able to total the
entire column. Sometimes some of the individual items are "included"
and sometimes they are not. If they are not included in the main
price I need to include their individual prices in the column total.
If the items ARE included in the main price the word "included" will
appear instead of the feature's individual price, but I still need to
be able to total the column. The SUM function returns a #VALUE!
error.

Main price 240000
feature A 80000
feature B 9500
feature C Included
Feature D 93000

TOTAL 422500

How can I sum a column that has at least one number in it although
there may also me non-numerics in it?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV files and having numbers and strings in there... 9
How to ignore a column of numbers in Grand Total for rows 1
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Sum all Values in a changing Column 15
Total a column contingent upon the cell to the right being non-bla 3
IF Function formula 3
requiring column entries 1
Formula re value in column C or D, calculations made on either in column E? 8

Top