Hi,
I have the following subtotals report.
I want to be able to count the number of Classes using each supplier as well as a total spend for eacdh supplier. The subtotal report totals the spend correctly but how do I count the number of classes. ie for Supplier A & B there is only 1 class using this supplier but for Supplier C there are 2. Any ideas?
I have the following subtotals report.
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Vendor | Spend | Class | |||
2 | SupplierA | $29.01 | 1 | |||
3 | SupplierA | $2,357.18 | 1 | |||
4 | SupplierA | $530.29 | 1 | |||
5 | SupplierA | $2,612.01 | 1 | |||
6 | SupplierATotal | $5,528.49 | ||||
7 | SupplierB | $518.19 | 2 | |||
8 | SupplierB | $499.17 | 2 | |||
9 | SupplierB | $514.72 | 2 | |||
10 | SupplierBTotal | $1,532.08 | ||||
11 | SupplierC | $516.53 | 1 | |||
12 | SupplierC | $532.94 | 1 | |||
13 | SupplierC | $217.00 | 2 | |||
14 | SupplierC | $453.99 | 2 | |||
15 | SupplierC | $779.99 | 2 | |||
16 | SupplierCTotal | $2,500.45 | ||||
Sheet1 |
I want to be able to count the number of Classes using each supplier as well as a total spend for eacdh supplier. The subtotal report totals the spend correctly but how do I count the number of classes. ie for Supplier A & B there is only 1 class using this supplier but for Supplier C there are 2. Any ideas?