How to add the sum of a cell with letter and numbers

February 11, 2012 at 13:45:37
Specs: Windows 7
Trying to add a couple of cells together, for a sales chart. I want to add just the numbers in each cell

Pretend a1-a11 looks something like this:

(dress) 20, (shoes) 15, Hat 15, 20, (earrings) 41

how would I make the sales add up?


See More: How to add the sum of a cell with letter and numbers

Report •

#1
February 11, 2012 at 14:29:39
if the cells only have numbers, you can use below (assuming you are talking about excel)

=SUM(A1:A11)

Not sure how i would achieve this if cells have extra characters.

- Subhash
 Monthly giveaway -  Must have Online safety Guide


Report •

#2
February 11, 2012 at 15:01:02
Yes I am talking about excel. Does anyone know how to add some if the cells contain both letters and numbers? I only need the sum of the numbers.

Report •

#3
February 11, 2012 at 17:44:58
If your data looks like this:

      A	    B    C     D  E   F  G     H       I  J
1) (dress) 20 (shoes) 15 Hat 15 20 (earrings) 41 111

Then using =SUM(A1:I1) gives you 111

NOTE that there are NO commas following the numbers.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
February 11, 2012 at 19:10:39
You asked us to pretend that a1-a11 looks something like this:

(dress) 20, (shoes) 15, Hat 15, 20, (earrings) 41

That is something that I can not pretend to do.

I don't know if you mean that each cell in A1:A11 contains a string of mixed text and numbers or if you mean that each cell contains one of those pieces of text and/or number or what.

What not click on the following line and read the instructions found via that link? Then come on back and post a real example of your data in a format that we can understand. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#5
February 12, 2012 at 15:07:35
Yes the cells have both letters and numbers in them. It actually a sales chart.

Across the top
A B C contines to M then it totals
Sale 1 Sales 2 Sales 3

1 Rings 10
2 Bracelet
3 Other shoes 5

The other cells are the ones with text and number because a description is needed

Is there a way to include a screen shot?



Report •

#6
February 13, 2012 at 15:05:28
Is there a way to include a screen shot?

Yes, UPload it to tinypic or anyother image hosting site and either give link to the image or use tag

- Subhash
 Monthly giveaway -  Must have Online safety Guide


Report •

#7
February 13, 2012 at 16:04:13
Obviously you didn't read the instructions on how to post data in this forum.

I'll try again - in bold this time - just in case you missed it in my previous response:

What not click on the following line and read the instructions found via that link? Then come on back and post a real example of your data in a format that we can understand. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#8
February 14, 2012 at 09:17:58
I don't know why all your comments seem so rude but I did read your link. I don't know what a vba code was and I don't understand alot of the other verbage you use. I am very new to excel. I only just learned about formatting from a youtube video i saw a couple of days ago. But thank you away for all your help. I will figure out the rest on my own.

Report •

#9
February 14, 2012 at 10:50:46
The link also included instructions on how to post data in this forum.

The instructions for posting data have nothing to do with Excel as they only relate to how to post data in this forum so that the columns line up corectly and we can understand your data better.

For example, you posted this:

A B C contines to M then it totals
Sales 1 Sales 2 Sales 3

1 Rings 10
2 Bracelet
3 Other shoes 5

What we would like to see is something like this so that we can tell which columns contains what data:

        A          B            C 
      Sales 1    Sales 2      Sales 3

1     Rings         10
2     Bracelet
3     Other        shoes         5 

Without the correct formatting, it is very difficult for us to offer specific solutions since we don't know what columns to use in the formulas.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question