Calculating multiple columns

babypink2807

New Member
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

Last edited:

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

FormR

MrExcel MVP
Hi, something like this maybe:

Excel 2013
ABCDEFG
1StatusQtyDepotDepotStatusCount
2Available10101Available1
3Available10201Repair1
4Repair101
5Collect102
Sheet1
Cell Formulas
RangeFormula
G2=COUNTIFS(\$C\$2:\$C\$5,E2,\$A\$2:\$A\$5,F2)

Replies
1
Views
2K
Replies
1
Views
574
Replies
0
Views
3K
Replies
1
Views
3K
Replies
2
Views
258

1,190,766
Messages
5,982,817
Members
439,798
Latest member
tangojuliet

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back