coulmn subtotal different models

[syd_p]

Hi,

I have a column with 5 000 rows that contains different models in text
form, Iphone4, Iphone3GS etc.
I want to create a sortedd list with subtotals fro each mode how can I
do that, please?
I guess that is kindof a basic question, but any help will be
appreciated!

TIA

-Syd

 

[Pete_UK]

You've told us that one column contains text values like Iphone4, but
nothing else. What other columns do you have? What is it that you want
to subtotal? The quantity of each model? Sales values? Stock values?

Please be more specific about your requirements.

Pete

 

[Gord Dibben]

1. Sort the data so it falls into groups.

2. Data>Subtotal>At each change in>Count

Or create a pivot table if data is more complex.


Gord Dibben MS Excel MVP

 

[Don Guillett Excel MVP]

Hi,

I have a column with 5 000 rows that contains different models in text
form, Iphone4, Iphone3GS etc.
I want to create a sortedd list with subtotals fro each mode how can I
do that, please?
I guess that is kindof a basic question, but any help will be
appreciated!

TIA

-Syd

Show your layout or
"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."

 

[The Chief Instigator]

Hi,

I have a column with 5 000 rows that contains different models in text
form, Iphone4, Iphone3GS etc.
I want to create a sortedd list with subtotals fro each mode how can I
do that, please?
I guess that is kindof a basic question, but any help will be
appreciated!

TIA

-Syd

It's not that difficult: If you start the column data at row 1, then you
put subtotals for the given models in a blank column. If you're counting
"Iphone4", enter "=countif(a2:a5001="Iphone4") and substitute the other
models in that format. (I'm using Excel 2010 for AHL and NHL standings, NFL
standings, and NBA and MLS. I'd consider MLB, but that's 2460 lines of
scores.)

 

[Gord Dibben]

Chief

I think you meant to post =COUNTIF(A2:A5001,"Iphone4")

Also, it would be much faster and easier to use Data>Subtotals to achieve same
results.


Gord Dibben MS Excel MVP

 

[The Chief Instigator]

Chief

I think you meant to post =COUNTIF(A2:A5001,"Iphone4")

Also, it would be much faster and easier to use Data>Subtotals to achieve same
results.

I'm used to Excel 2010, but I can get used to that, what with AHL standing
spreadsheets with sumproducts to match the teams of how many wins and
losses, home and away, with a 1200-game schedule. MLB would take me until
next season. `-)