Spreadsheet: 804944d1668442916-want-to-sum-values-across-multiple-sheets-with-multiple-criteria-chemical-usage
Sheet: Total Usage

 |  | Product Start
 |  | Product Used
 |  | Product Remaining
 |  |  |  |  |  |  | MAY |  |  | [NAME] |  |  | JULY |  | AUGUST |  | SEPTEMBER
 | Serial # | Product remaining | Product Start | Product Used | *Expected Value for Multisheet Calculation* | Returned/Other | East | West | Main East | Main West | East | West | East | West | East | West | East | West | Polymerized | RETURNED
adam | E8607 |  | 0 |  |  | used in 2020
adam | E8629 |  | 0 |  | 12 | used in 2020
adam | E8449 |  | 52.4 |  |  | Full in IRP Yard  BI |  |  |  |  |  |  |  | 52.4
adam | C3420 |  | 52.4 |  |  | Full in IRP Yard  BI Used 2022 |  |  |  |  |  | 52.4
adam | AA954283 |  | 52.4 |  |  | Full in IRP Yard  BI Used 2022 |  |  |  |  |  |  |  |  |  | 52.4
adam | AA955173 |  | 52.4 |  |  | Full in IRP Yard  BI Used 2022 |  |  |  |  |  | 52.4
 | AA954247 |  | 52.4 |  |  | [NAME] 18, 2022 | 52.4
 | AA956060 |  | 0 |  |  | [NAME] 18, 2022
 | C3165 |  | 52.4 |  |  | [NAME] 18, 2022 | 52.4
 | AA953433 |  | 0 |  |  | [NAME] 18, 2022
adam | C2813 |  | 52.4 |  |  | Full in IRP Yard  BI Used 2022 |  |  |  |  |  | 52.4
 | AA955124 |  | 0 |  |  | [NAME] 18, 2022
 | AA953423 |  | 0 |  |  | [NAME] 18, 2022
 | C2589 |  | 18.51 |  |  | [NAME] 18, 2022, Empty in IRP yard BI, incorrect volume to start, or guages are incorrect | 18.51
???? | E8905 |  | 0
 | C3175 |  | 0 |  |  | [NAME] 18, 2022
 | AA954293 |  | 0
New 2022 | E9193 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | E9099 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  | 52.4
adam | E8478 |  | 52.4 |  |  |  |  |  |  |  |  |  |  | 52.4
 | E8827 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | E8488 |  | 52.4 |  |  |  |  |  |  |  | 52.4
 | E8674 |  | 52.4 |  |  |  |  |  |  |  | 52.4
 | E9076 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | E8489 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | E9225 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | E8691 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | E8451 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  | 52.4
 | E8948 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  | 52.4
Adam | AA952376 |  | 52.4 |  |  |  |  | 52.4
Adam | E8974 |  | 52.4 |  |  |  |  | 52.4
 | E8652 |  | 52.4 |  |  |  |  |  |  |  | 52.4
 | E8729 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | E8654 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  | 52.4
 | E9053 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  | 52.4
adam | E8556 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | E9062 |  | 52.4 |  |  | [NAME] 18, 2022,Polymerized bottle, but empty. |  |  |  |  | 52.4
 | E8533 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | E9195 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  |  |  | 52.4
 | E9250 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | E8403 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  | 52.4
 | E9103 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | E8887 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  | 52.4
 | E8586 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | E8553 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  |  |  | 52.4
 | E8642 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  | 52.4
 | E8897 |  | 52.4 |  |  |  |  |  |  |  | 52.4
 | E9249 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  | 52.4
 | E9289 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  | 52.4
 | E8595 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  | 52.4
 | E9149 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | E8970 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  |  |  | 52.4
 | E8989 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | E8578 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | E9262 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  |  |  |  |  | 52.4
 | E8859 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | E8479 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | E8916 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
adam | E9223 |  | 52.4 |  |  |  |  |  |  |  |  |  |  | 52.4
 | C2790 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | C3020 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | C2966 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | C2612 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | C3032 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | C3122 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | C3430 |  | 52.4 |  | 18 | [NAME] 18, 2022 |  |  |  |  | 52.4
 | C2544 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | C3367 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | C3036 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | AA955170 |  | 52.4 |  |  |  |  |  |  |  |  |  |  | 52.4
 | AA954248 |  | 52.4 |  | 25 |  |  |  |  |  |  |  |  | 52.4
 | AA955159 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | AA952355 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | C2433 |  | 52.4 |  |  |  |  |  |  |  | 52.4
 | C2855 |  | 52.4 |  |  |  |  |  |  |  | 52.4
 | C2633 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | C2903 |  | 52.4 |  |  | [NAME] 18, 2022 |  |  |  |  | 52.4
 | C2641 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | C2793 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | [NAME] |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | C2348 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 52.4
 | C2334 |  | 52.4 |  |  | In [NAME] |  |  |  |  |  |  |  |  |  |  | 39.48
 | C2557 |  | 52.4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 52.4
 |  |  |  |  |  |  | MAY |  |  | [NAME] |  |  | JULY |  | AUGUST |  | SEPTEMBER
 |  |  |  |  |  |  | East | West | Main East | Main West | East | West | East | West | East | West | East | West