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

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