Thread: Sums from list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
---