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?

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.

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.

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 111Then using =SUM(A1:I1) gives you 111

NOTE that there are NO commas following the numbers.

MIKE

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.

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 neededIs there a way to include a screen shot?

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

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.

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.

The link also included instructions on how to post datain 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 31 Rings 10

2 Bracelet

3 Other shoes 5What 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 5Without 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.

Ask Your Question

Weekly Poll