Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Auto-summing similar lines
10 views
Skip to first unread message
AuditorLisa
May 21, 2012, 3:39:22 PM5/21/12
to
I have a list of names and payments for each person. Most people are
listed more than once. I am trying to auto sum each person so there's
only one value person.
Any suggestions as to how to do this?
example:
Kendra $750.00
Kendra $375.00
Tyeisha $495.00
Tyeisha $247.50
Daniel $750.00
Daniel $750.00
Daniel $750.00
Joshua $750.00
Yolanda $750.00
Yolanda $750.00
Akiesha $750.00
Jessica $750.00
Jessica $750.00
Rodarial $750.00
Rodarial $750.00
--
AuditorLisa
Gord Dibben
May 21, 2012, 6:25:51 PM5/21/12
to
Data>Subtotals
Make sure you have a Title for each column.........Name........Amount
At each change in name.....sum.......add subtotal to........amount
Click on the 2 from the 123 to see only each person's subtotal.
Gord
Make sure you have a Title for each column.........Name........Amount
At each change in name.....sum.......add subtotal to........amount
Click on the 2 from the 123 to see only each person's subtotal.
Gord
AuditorLisa
May 22, 2012, 10:24:19 AM5/22/12
to
Gord,
Thank you for your response. I'm having some trouble understanding what
you are saying to do. I'm not an excell expert by any means so I
apologize. Could you explain more how you are saying to do this?
'Gord Dibben[_2_ Wrote:
> ;1601988']Data>Subtotals
>
> Make sure you have a Title for each column.........Name........Amount
>
> At each change in name.....sum.......add subtotal to........amount
>
> Click on the 2 from the 123 to see only each person's subtotal.
>
>
> Gord
>
> On Mon, 21 May 2012 19:39:22 +0000, AuditorLisa
> <labosse...@liberty.edu.REMOVE> wrote:
> -
> Make sure you have a Title for each column.........Name........Amount
>
> At each change in name.....sum.......add subtotal to........amount
>
> Click on the 2 from the 123 to see only each person's subtotal.
>
>
> Gord
>
> On Mon, 21 May 2012 19:39:22 +0000, AuditorLisa
> <labosse...@liberty.edu.REMOVE> wrote:
> >
> >I have a list of names and payments for each person. Most people are
> >listed more than once. I am trying to auto sum each person so there's
> >only one value person.
> >
> >Any suggestions as to how to do this?
> >
> >example:
> >Kendra $750.00
> >Kendra $375.00
> >Tyeisha $495.00
> >Tyeisha $247.50
> >Daniel $750.00
> >Daniel $750.00
> >Daniel $750.00
> >Joshua $750.00
> >Yolanda $750.00
> >Yolanda $750.00
> >Akiesha $750.00
> >Jessica $750.00
> >Jessica $750.00
> >Rodarial $750.00
> >Rodarial $750.00-
> >I have a list of names and payments for each person. Most people are
> >listed more than once. I am trying to auto sum each person so there's
> >only one value person.
> >
> >Any suggestions as to how to do this?
> >
> >example:
> >Kendra $750.00
> >Kendra $375.00
> >Tyeisha $495.00
> >Tyeisha $247.50
> >Daniel $750.00
> >Daniel $750.00
> >Daniel $750.00
> >Joshua $750.00
> >Yolanda $750.00
> >Yolanda $750.00
> >Akiesha $750.00
> >Jessica $750.00
> >Jessica $750.00
> >Rodarial $750.00
--
AuditorLisa
Gord Dibben
May 23, 2012, 2:28:46 PM5/23/12
to
Expert status not necessary to use Data>Subtotals
Assuming your two columns are A and B
Insert a row at top.
In A1 enter the title......"name".........no quotes
In B1 enter the title......"amount".......no quotes
Select A1
On your main menu bar(or ribbon if using 2007 version of Excel) you
will see Data.
Click on that and select Subtotal.
A dialog box will show.....
First line is "at each change in"......you select "name"
Second line is "use function".........you select "Sum"
Third line is "add subtotal to"..........you select "amount"
Keep or remove the checkmark in "Summary below data".........your
choice.
Click OK
You will now have a new column at left of Column A
Note the + and - signs............they are there for you to expand or
collapse the list.
Note the 123 across top of this new column.
Click on 2 to see just the unique names and their totals.
Play with 123 to see expansion or collapse of data.
To remove the column and subtotals click on Data>Subtotals>Remove All
Gord
Assuming your two columns are A and B
Insert a row at top.
In A1 enter the title......"name".........no quotes
In B1 enter the title......"amount".......no quotes
Select A1
On your main menu bar(or ribbon if using 2007 version of Excel) you
will see Data.
Click on that and select Subtotal.
A dialog box will show.....
First line is "at each change in"......you select "name"
Second line is "use function".........you select "Sum"
Third line is "add subtotal to"..........you select "amount"
Keep or remove the checkmark in "Summary below data".........your
choice.
Click OK
You will now have a new column at left of Column A
Note the + and - signs............they are there for you to expand or
collapse the list.
Note the 123 across top of this new column.
Click on 2 to see just the unique names and their totals.
Play with 123 to see expansion or collapse of data.
To remove the column and subtotals click on Data>Subtotals>Remove All
Gord
AuditorLisa
May 24, 2012, 10:09:42 AM5/24/12
to
Thank you Gord! You have seriously just saved me days and days of
pointless work! I really appreciate it
'Gord Dibben[_2_ Wrote:
> ;1602052']Expert status not necessary to use Data>Subtotals
> >
> >Gord,
> >
> >Thank you for your response. I'm having some trouble understanding
> what
> >you are saying to do. I'm not an excell expert by any means so I
> >apologize. Could you explain more how you are saying to do this?
> >
> >'Gord Dibben[_2_ Wrote: -
> >Gord,
> >
> >Thank you for your response. I'm having some trouble understanding
> what
> >you are saying to do. I'm not an excell expert by any means so I
> >apologize. Could you explain more how you are saying to do this?
> >
> >> ;1601988']Data>Subtotals
> >>
> >> Make sure you have a Title for each
> column.........Name........Amount
> >>
> >> At each change in name.....sum.......add subtotal to........amount
> >>
> >> Click on the 2 from the 123 to see only each person's subtotal.
> >>
> >>
> >> Gord
> >>
> >> On Mon, 21 May 2012 19:39:22 +0000, AuditorLisa
> >> <labosse...@liberty.edu.REMOVE> wrote:
> >> --
> >>
> >> Make sure you have a Title for each
> column.........Name........Amount
> >>
> >> At each change in name.....sum.......add subtotal to........amount
> >>
> >> Click on the 2 from the 123 to see only each person's subtotal.
> >>
> >>
> >> Gord
> >>
> >> On Mon, 21 May 2012 19:39:22 +0000, AuditorLisa
> >> <labosse...@liberty.edu.REMOVE> wrote:
> >> >
> >> >I have a list of names and payments for each person. Most people
> are
> >> >listed more than once. I am trying to auto sum each person so
> there's
> >> >only one value person.
> >> >
> >> >Any suggestions as to how to do this?
> >> >
> >> >example:
> >> >Kendra $750.00
> >> >Kendra $375.00
> >> >Tyeisha $495.00
> >> >Tyeisha $247.50
> >> >Daniel $750.00
> >> >Daniel $750.00
> >> >Daniel $750.00
> >> >Joshua $750.00
> >> >Yolanda $750.00
> >> >Yolanda $750.00
> >> >Akiesha $750.00
> >> >Jessica $750.00
> >> >Jessica $750.00
> >> >Rodarial $750.00
> >> >Rodarial $750.00----
> >> >I have a list of names and payments for each person. Most people
> are
> >> >listed more than once. I am trying to auto sum each person so
> there's
> >> >only one value person.
> >> >
> >> >Any suggestions as to how to do this?
> >> >
> >> >example:
> >> >Kendra $750.00
> >> >Kendra $375.00
> >> >Tyeisha $495.00
> >> >Tyeisha $247.50
> >> >Daniel $750.00
> >> >Daniel $750.00
> >> >Daniel $750.00
> >> >Joshua $750.00
> >> >Yolanda $750.00
> >> >Yolanda $750.00
> >> >Akiesha $750.00
> >> >Jessica $750.00
> >> >Jessica $750.00
> >> >Rodarial $750.00
--
AuditorLisa
Gord Dibben
May 24, 2012, 4:16:57 PM5/24/12
to
Good to hear you got sorted out.
Thanks for the feedback.
Gord
Thanks for the feedback.
Gord
0 new messages