coulmn subtotal different models

  • Thread starter Thread starter syd_p
  • Start date Start date
S

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
 
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
 
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
 
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
Click to expand...

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."
 
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
Click to expand...

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.)
 
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
 
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.
Click to expand...

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. `-)
 
Back
Top