Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Up Q
I am looking to add up all Values in Column E (quantities of products sold) for each product by store. The effect of this is that all Products that are the same (which are in Column C) that relate to the same store (which are detailed in Column A) are totalled up. I then wish to delete these rows (that have been added and are thus no longer needed) - something likea subtotal except I only want the 'subtotal' rows One way I thought I could do it might be add when A2=A3 AND OR C2 = C3, these would continue progressing down my worksheet until A2 does not equal A3 i.e. new Store and C2 does not equal C3 i.e. new product Hope that make sense Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Up Q
Hi
I would use a pivot table for this. see: http://www.cpearson.com/excel/pivots.htm http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/xlPivot02.html http://www.ozgrid.com/Excel/excel-pivot-tables.htm -- Regards Frank Kabel Frankfurt, Germany John wrote: I am looking to add up all Values in Column E (quantities of products sold) for each product by store. The effect of this is that all Products that are the same (which are in Column C) that relate to the same store (which are detailed in Column A) are totalled up. I then wish to delete these rows (that have been added and are thus no longer needed) - something likea subtotal except I only want the 'subtotal' rows One way I thought I could do it might be add when A2=A3 AND OR C2 = C3, these would continue progressing down my worksheet until A2 does not equal A3 i.e. new Store and C2 does not equal C3 i.e. new product Hope that make sense Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|