Consolidating Columns of data

[MCattz]

I am trying to consolidate how much equipment is issued to a location over a year, this equipment is recorded in a spreadsheet each time it is issued by date, the spreadsheet contains columns for each unit over that time. I would like to consolidate this into a second tab that consolidates all of the columns by location

		Equipment Issued
	Date	1/01/2014	1/01/2014	3/01/2014	8/01/2014
	Location	Location X	Location Y	Location X	Location Z
Equipment Issued
CHAINSAWS & ACCESSORIES		2	1	2
Chainsaw		2
Chainsaw		2
Chainsaw		2
Chainsaw		2
Chainsaw		1
Polesaw		9
Polesaw Harness
Chain sharpener
Vacuum cleaner
Quick cut
Bar oil
Chainsaw Bar
Chainsaw Bar
Chainsaw Bar
Chainsaw Bar

<tbody>
</tbody>

The data from the table above needs to be collated into the table below:

	Location X	Location Y	Location Z
CHAINSAWS & ACCESSORIES
Chainsaw
Chainsaw
Chainsaw
Chainsaw
Multi purpose rescue tool
Polesaw
Polesaw Harness
Chain sharpener
Vacuum cleaner
Quick cut
Bar oil
Chainsaw Bar
Chainsaw Bar
Chainsaw Bar
Chainsaw Bar

<tbody>
</tbody>

 

[jparfitt87]

Hi MCattz,
I have used something similar to this myself so should hopefully be able to help with this.
I used a very simple sum if formula across the dates and locations. as below:

=SUMIF(Sheet1!C2:F2,Sheet2!B1,Sheet1!C4:F4)

Sheet1 being the daily tracker,
Sheet2 being the consolodated view

Sheet1!C2:F2 is the range for the locations.
Sheet2!B1 is the Range Criteria ie Location X
Sheet1!C4:F4 Is the sum Range ie this counts how many items have been issued.

I hope you find this useful