Spreadsheet: 462441d1464042556-average-column-cells-with-multiple-conditions-help
Sheet: Sheet1

Supplier | Steel | Request Date | Submission Date | Avg Days | Approval Date |  | Average Days |  |  | HELP 1 |  |  | HELP 2
GGG | Raw | 2016-01-04 00:00:00 | 2016-01-06 00:00:00 | 2 | 2016-01-08 00:00:00 |  |  |  |  |  |  |  | Average Days for Monthly Approval by Commodity
GGG | Steel | 2016-01-06 00:00:00 | 2016-01-07 00:00:00 | 1 | 2016-01-08 00:00:00 |  |  |  |  | Date | Total Average Days for Approval |  | Commodities | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00
GGG | Raw | 2016-01-11 00:00:00 | 2016-01-11 00:00:00 | 0 | 2016-01-12 00:00:00 |  |  |  |  | 2016-01-01 00:00:00 |  |  | Raw
AAA | Steel | 2016-01-07 00:00:00 | 2016-01-12 00:00:00 | 5 | 2016-01-13 00:00:00 |  |  |  |  | 2016-02-01 00:00:00 |  |  | Steel
GGG | Raw | 2016-01-11 00:00:00 | 2016-01-12 00:00:00 | 1 | 2016-01-13 00:00:00 |  |  |  |  | 2016-03-01 00:00:00 |  |  | Finished
HHH | Steel | 2016-01-13 00:00:00 | 2016-01-14 00:00:00 | 1 | 2016-01-15 00:00:00 |  |  |  |  | 2016-04-01 00:00:00
GGG | Raw | 2016-01-13 00:00:00 | 2016-01-15 00:00:00 | 2 | 2016-01-18 00:00:00 |  |  |  |  | 2016-05-01 00:00:00
GGG | Raw | 2016-01-08 00:00:00 | 2016-01-18 00:00:00 | 10 | 2016-01-19 00:00:00 |  |  |  |  | 2016-06-01 00:00:00
GGG | Raw | 2016-01-18 00:00:00 | 2016-01-19 00:00:00 | 1 | 2016-01-20 00:00:00 |  |  |  |  | 2016-07-01 00:00:00
GGG | Raw | 2016-01-13 00:00:00 | 2016-01-19 00:00:00 | 6 | 2016-01-21 00:00:00 |  |  |  |  | 2016-08-01 00:00:00
GGG | Raw | 2016-01-18 00:00:00 | 2016-01-19 00:00:00 | 1 | 2016-01-21 00:00:00 |  |  |  |  | 2016-09-01 00:00:00
III | Steel | 2016-01-13 00:00:00 | 2016-01-20 00:00:00 | 7 | 2016-01-26 00:00:00 |  |  |  |  | 2016-10-01 00:00:00
GGG | Finished | 2016-01-15 00:00:00 | 2016-01-22 00:00:00 | 7 | 2016-01-28 00:00:00 |  |  |  |  | 2016-11-01 00:00:00
JKKK | Finished | 2016-01-14 00:00:00 | 2016-02-02 00:00:00 | 19 | 2016-02-03 00:00:00 |  |  |  |  | 2016-12-01 00:00:00
GGG | Finished | 2016-02-02 00:00:00 | 2016-02-03 00:00:00 | 1 | 2016-02-04 00:00:00 |  |  |  |  | 2017-01-01 00:00:00
K | Finished | 2016-02-07 00:00:00 | 2016-02-08 00:00:00 | 1 | 2016-02-11 00:00:00 |  |  |  |  | 2017-02-01 00:00:00
KKK | Finished | 2016-02-09 00:00:00 | 2016-02-10 00:00:00 | 1 | 2016-02-11 00:00:00 |  |  |  |  | 2017-03-01 00:00:00
GGG | Finished | 2016-02-09 00:00:00 | 2016-02-10 00:00:00 | 1 | 2016-02-12 00:00:00 |  |  |  |  | 2017-04-01 00:00:00
YY | Finished | 2016-02-05 00:00:00 | 2016-02-12 00:00:00 | 7 | 2016-02-15 00:00:00 |  |  |  |  | 2017-05-01 00:00:00
GGG | Steel | 2016-02-03 00:00:00 | 2016-02-19 00:00:00 | 16 | 2016-02-26 00:00:00 |  |  |  |  | 2017-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2017-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2017-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2017-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2017-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2017-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2017-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2018-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2018-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2018-03-01 00:00:00