Calculating multiple columns

[babypink2807]

Hi guys

I am trying to work out how many items for one depot are either on hire, available or being collected I can easily add up and split up how many items each depot has, thats easy using -COUNTIF(E2:E1524, "01"). But now I need to split that down further into how many of those items are on hire, or available

My data is as follows

Status	Qty	Depot
Available	1	01
Available	1	02
Repair	1	01
Collect	1	02

<tbody>
</tbody>

So in theory in Total I have 4 items

Depot 01 has 2 items, 1 in repair and 1 Available
Depot 02 has 2 items, 1 Available and 1 to collect

I would like to produce a pie chart that shows Depot 01 has 2 items of which it is split in to 1 available and 1 in repair? basically its 50% of each. In my true data I have over 1500 items

Hope that makes sense

 

[FormR]

Hi, something like this maybe:

Excel 2013
	A	B	C	D	E	F	G
1	Status	Qty	Depot		Depot	Status	Count
2	Available	1	01		01	Available	1
3	Available	1	02		01	Repair	1
4	Repair	1	01
5	Collect	1	02
Sheet1

Cell Formulas
Range	Formula
G2	=COUNTIFS($C$2:$C$5,E2,$A$2:$A$5,F2)