Spreadsheet: 98628d1297475405-matching-3-columns-with-criteria-and-calculation-3colpvt
Sheet: Sheet1

DATE | COMPANY ID | ITEM | UOM | COST
2009-01-02 00:00:00 | 1111111 | 1 | BX | 10
2009-02-03 00:00:00 | 1111111 | 1 | EA | 10
2009-03-07 00:00:00 | 2222222 | 1 | BX | 10
2009-04-08 00:00:00 | 1111111 | 1 | BX | 20
2009-05-10 00:00:00 | 2222222 | 2 | EA | 10 |  | DATE | (All)
2009-06-11 00:00:00 | 2222222 | 2 | BX | 20
2009-07-13 00:00:00 | 3333333 | 2 | BX | 10 |  |  |  |  | Data
2009-08-14 00:00:00 | 3333333 | 1 | EA | 20 |  | COMPANY ID | ITEM | UOM | Sum of COST | Average of COST
2009-09-15 00:00:00 | 4444444 | 2 | BX | 40 |  | 1111111 | 1 | BX | 130 | 43.33333333333334
2009-10-17 00:00:00 | 4444444 | 1 | BX | 10 |  |  |  | EA | 60 | 30
2009-11-18 00:00:00 | 1111111 | 2 | EA | 20 |  |  | 1 Total |  | 190 | 38
2009-12-20 00:00:00 | 1111111 | 2 | BX | 10 |  |  | 2 | BX | 130 | 43.33333333333334
2010-01-21 00:00:00 | 3333333 | 2 | BX | 10 |  |  |  | EA | 80 | 26.66666666666667
2010-02-22 00:00:00 | 3333333 | 2 | EA | 20 |  |  | 2 Total |  | 210 | 35
2010-03-26 00:00:00 | 4444444 | 1 | BX | 10 |  |  | 3 | BX | 100 | 100
2010-04-27 00:00:00 | 1111111 | 2 | BX | 20 |  |  |  | EA | 50 | 50
2010-05-29 00:00:00 | 1111111 | 2 | EA | 10 |  |  | 3 Total |  | 150 | 75
2010-06-30 00:00:00 | 2222222 | 3 | BX | 20 |  | 1111111 Total |  |  | 550 | 42.30769230769231
2010-07-01 00:00:00 | 2222222 | 3 | BX | 40 |  | 2222222 | 1 | BX | 110 | 55
2010-08-01 00:00:00 | 1111111 | 1 | EA | 50 |  |  |  | EA | 50 | 50
2010-08-01 00:00:00 | 2222222 | 1 | EA | 50 |  |  | 1 Total |  | 160 | 53.33333333333334
2010-08-01 00:00:00 | 3333333 | 1 | EA | 50 |  |  | 2 | BX | 120 | 60
2010-08-01 00:00:00 | 4444444 | 1 | EA | 50 |  |  |  | EA | 60 | 30
2010-08-01 00:00:00 | 1111111 | 1 | BX | 100 |  |  | 2 Total |  | 180 | 45
2010-08-01 00:00:00 | 2222222 | 1 | BX | 100 |  |  | 3 | BX | 160 | 53.33333333333334
2010-08-01 00:00:00 | 3333333 | 1 | BX | 100 |  |  |  | EA | 50 | 50
2010-08-01 00:00:00 | 4444444 | 1 | BX | 100 |  |  | 3 Total |  | 210 | 52.5
2010-08-01 00:00:00 | 1111111 | 2 | EA | 50 |  | 2222222 Total |  |  | 550 | 50
2010-08-01 00:00:00 | 2222222 | 2 | EA | 50 |  | 3333333 | 1 | BX | 100 | 100
2010-08-01 00:00:00 | 3333333 | 2 | EA | 50 |  |  |  | EA | 70 | 35
2010-08-01 00:00:00 | 4444444 | 2 | EA | 50 |  |  | 1 Total |  | 170 | 56.66666666666666
2010-08-01 00:00:00 | 1111111 | 2 | BX | 100 |  |  | 2 | BX | 120 | 40
2010-08-01 00:00:00 | 2222222 | 2 | BX | 100 |  |  |  | EA | 70 | 35
2010-08-01 00:00:00 | 3333333 | 2 | BX | 100 |  |  | 2 Total |  | 190 | 38
2010-08-01 00:00:00 | 4444444 | 2 | BX | 100 |  |  | 3 | BX | 100 | 100
2010-08-01 00:00:00 | 1111111 | 3 | EA | 50 |  |  |  | EA | 50 | 50
2010-08-01 00:00:00 | 2222222 | 3 | EA | 50 |  |  | 3 Total |  | 150 | 75
2010-08-01 00:00:00 | 3333333 | 3 | EA | 50 |  | 3333333 Total |  |  | 510 | 51
2010-08-01 00:00:00 | 4444444 | 3 | EA | 50 |  | 4444444 | 1 | BX | 120 | 40
2010-08-01 00:00:00 | 1111111 | 3 | BX | 100 |  |  |  | EA | 50 | 50
2010-08-01 00:00:00 | 2222222 | 3 | BX | 100 |  |  | 1 Total |  | 170 | 42.5
2010-08-01 00:00:00 | 3333333 | 3 | BX | 100 |  |  | 2 | BX | 140 | 70
2010-08-01 00:00:00 | 4444444 | 3 | BX | 100 |  |  |  | EA | 50 | 50
 |  |  |  |  |  |  | 2 Total |  | 190 | 63.33333333333334
 |  |  |  |  |  |  | 3 | BX | 100 | 100
 |  |  |  |  |  |  |  | EA | 50 | 50
 |  |  |  |  |  |  | 3 Total |  | 150 | 75
 |  |  |  |  |  | 4444444 Total |  |  | 510 | 56.66666666666666
 |  |  |  |  |  | Grand Total |  |  | 2120 | 49.30232558139535