Technical Discussion
  >> Windows Issues


Register (or login) on our website and you will not see this ad.


  Print Thread
Standard User DavidFinbarr
(freechataholic) Mon 28-Oct-13 11:26:09
Print Post

Excel help needed.


[link to this post]
 
Have a spreadsheet that has various shops on it EG "John Lewis" it will appear on different rows and columns.
In the cell to the right on it is a value which is the spend.

What I'm hoping to do it get a formula that calculates the total spend at JL.

Save a bird,
eat a cat.
Standard User ian72
(knowledge is power) Mon 28-Oct-13 12:00:14
Print Post

Re: Excel help needed.


[re: DavidFinbarr] [link to this post]
 
Can you do a quick sample as not sure the purpose to having it on different rows / columns. If it was in same column each time then you could use pivot tables or a "sumif" function.
Standard User DavidFinbarr
(freechataholic) Mon 28-Oct-13 12:12:22
Print Post

Re: Excel help needed.


[re: ian72] [link to this post]
 
Each month has a different column. "John Lewis" could appear in any row in that column
(the rows are in date order)

At the bottom of each column is the total of the column that will show total spend on all shops in that month.

If possible I want a formula that looks though the 12 columns and calculates the total spend at each shop.

Save a bird,
eat a cat.


Register (or login) on our website and you will not see this ad.

Standard User ian72
(knowledge is power) Mon 28-Oct-13 13:00:20
Print Post

Re: Excel help needed.


[re: DavidFinbarr] [link to this post]
 
=sumif(a1:a6,"John Lewis",b1:b6)+sumif(c1:c6,"John Lewis",d1:d6)

Adding a sumif for each column set until you have all 12.

Edited by ian72 (Mon 28-Oct-13 13:01:35)

Standard User DavidFinbarr
(freechataholic) Mon 28-Oct-13 13:11:50
Print Post

Re: Excel help needed.


[re: ian72] [link to this post]
 
Thank you, works a treat.

Save a bird,
eat a cat.
Standard User ian72
(knowledge is power) Mon 28-Oct-13 14:26:46
Print Post

Re: Excel help needed.


[re: DavidFinbarr] [link to this post]
 
Your welcome. Glad it worked.
Standard User DavidFinbarr
(freechataholic) Mon 28-Oct-13 21:34:09
Print Post

Re: Excel help needed.


[re: ian72] [link to this post]
 
Made a pie chart out of the info smile

Thanks again.

Save a bird,
eat a cat.
  Print Thread

Jump to