ExcelBanter - Sums from list

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sums from list (https://www.excelbanter.com/excel-discussion-misc-queries/183370-sums-list.html)

Benjamin

Sums from list

I have a list with people, day, qty. How can I get a list that only has
people and the total qty per person?

Max

Sums from list

"Benjamin" wrote:
I have a list with people, day, qty. How can I get a list that only has
people and the total qty per person?

One way: Create pivot, people into ROW area, qty into DATA area (as sum)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Benjamin

Sums from list

Is there a Macro to do this?

"Max" wrote:

"Benjamin" wrote:
I have a list with people, day, qty. How can I get a list that only has
people and the total qty per person?

One way: Create pivot, people into ROW area, qty into DATA area (as sum)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Max

Sums from list

"Benjamin" wrote:
Is there a Macro to do this?

You could record a macro when you construct it manually
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

All times are GMT +1. The time now is 11:28 PM.