Summing across multiple columns

[scwalio]

Hi,

I've had a search of this and can't seem to find exactly what I'
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 ove
2000 rows with the store type and revenue for each store. The number o
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 no
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
etc.

I've tried to lay out what I am looking at below, but if I haven't mad
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

et

 

[Don Guillett]

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

Send file and complete explanation and examples to dguillett @gmail.com