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

On Nov 27, 7:06*pm, syd_p <sydneypue...@yahoo.com> wrote:
> 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

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

On Sat, 27 Nov 2010 11:06:53 -0800 (PST), syd_p <(E-Mail Removed)> wrote:

>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

On Nov 27, 1:06*pm, syd_p <sydneypue...@yahoo.com> wrote:
> 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."

On Sat, 27 Nov 2010 11:06:53 -0800 (PST), syd_p <(E-Mail Removed)> wrote:
> 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.)

--
Patrick L. "The Chief Instigator" Humphrey ((E-Mail Removed)) Houston, TX
(http://www.io.com/~patrick) AA #2237
LAST GAME: Houston 2, Milwaukee 1 (SO, November 26)
NEXT GAME: Thursday, December 2 vs. Rockford, 11:05 AM

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


On 29 Nov 2010 02:09:39 GMT, The Chief Instigator <(E-Mail Removed)> wrote:

>On Sat, 27 Nov 2010 11:06:53 -0800 (PST), syd_p <(E-Mail Removed)> wrote:
>> 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.)

On Sun, 28 Nov 2010 20:39:49 -0800, Gord Dibben <(E-Mail Removed)> wrote:
> 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. `-)

--
Patrick L. "The Chief Instigator" Humphrey ((E-Mail Removed)) Houston, TX
(http://www.io.com/~patrick) AA #2237
LAST GAME: Houston 2, Milwaukee 1 (SO, November 26)
NEXT GAME: Thursday, December 2 vs. Rockford, 11:05 AM