Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summing across multiple columns
Hi,
I've had a search of this and can't seem to find exactly what I'm looking for, so apologies if this has already been asked! I have been given a dataset with around 50 columns by product type (e.g. Cornflakes, Bread, Milk etc) going across 1 sheet. Each column has over 2000 rows with the store type and revenue for each store. The number of stores is different for each column (e.g. cornflakes sold in 100 stores, bread sold in 200 stores etc). What I would like to do is to sum the total revenue for each store e.g. Store 1 makes £120 across all products etc. Unfortunately, the stores are in different orders in the columns and not all the columns have the same store. E.g. Cornflakes might have store 1, 3, 5 and 6, Bread might have store 2, 3, 4 and 5, Milk has 4, 2 and 1 etc. I've tried to lay out what I am looking at below, but if I haven't made myself clear, I will try and send across the Excel. Thanks! Cornflakes Bread Store No. Revenue (£) Store No. Revenue (£) Store 1 100 Store 1 20 Store 2 78 Store 2 55 Store 3 49 Store 3 82 etc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing across multiple columns
On Monday, August 6, 2012 11:13:34 AM UTC-5, scwalio wrote:
Hi, I've had a search of this and can't seem to find exactly what I'm looking for, so apologies if this has already been asked! I have been given a dataset with around 50 columns by product type (e.g. Cornflakes, Bread, Milk etc) going across 1 sheet. Each column has over 2000 rows with the store type and revenue for each store. The number of stores is different for each column (e.g. cornflakes sold in 100 stores, bread sold in 200 stores etc). What I would like to do is to sum the total revenue for each store e.g. Store 1 makes £120 across all products etc. Unfortunately, the stores are in different orders in the columns and not all the columns have the same store. E.g. Cornflakes might have store 1, 3, 5 and 6, Bread might have store 2, 3, 4 and 5, Milk has 4, 2 and 1 etc. I've tried to lay out what I am looking at below, but if I haven't made myself clear, I will try and send across the Excel. Thanks! Cornflakes Bread Store No. Revenue (£) Store No. Revenue (£) Store 1 100 Store 1 20 Store 2 78 Store 2 55 Store 3 49 Store 3 82 etc -- scwalio Send file and complete explanation and examples to dguillett @gmail.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summing data in multiple columns | Excel Discussion (Misc queries) | |||
Summing across columns while skipping some columns | Excel Worksheet Functions | |||
summing columns | Excel Worksheet Functions | |||
Summing Multiple Columns | Excel Worksheet Functions | |||
SUMIF summing multiple columns | Excel Worksheet Functions |