Spreadsheet: 876978d1723680016-calculating-sum-based-on-value-of-another-column-and-date-sample-sheet-for-calc
Sheet: Sheet1

Date | Status | Approx. Value | YTD Sales |  | Quotes Won by Month |  | Value Won by Month |  | Sales_Criteria
2017-05-05 00:00:00 | INACTIVE | 6216 | 2017 |  | JAN | =SUMIF(B:B,"=WON",C:C) | JAN |  | WON
2017-05-07 00:00:00 | INACTIVE | 7746 | 2018 |  | FEB |  | FEB |  | LOST
2017-05-10 00:00:00 | WON | 20666 | 2019 |  | MAR |  | MAR |  | ACTIVE
2017-05-12 00:00:00 | WON | 6750 | 2020 |  | APR |  | APR |  | INACTIVE
2017-05-12 00:00:00 | INACTIVE | 9261 | 2021 |  | MAY |  | MAY
2017-05-16 00:00:00 | INACTIVE | 14230 | 2022 |  | JUN |  | JUN
2017-05-17 00:00:00 | WON | 15929 | 2023 |  | JUL |  | JUL
2017-05-23 00:00:00 | INACTIVE | 5698 | 2024 |  | AUG |  | AUG
2017-05-30 00:00:00 | INACTIVE | 6216 | 2025 |  | SEP |  | SEP
2017-06-05 00:00:00 | INACTIVE | 6215 | Total |  | OCT |  | OCT
2017-06-13 00:00:00 | INACTIVE | 6750 |  |  | NOV |  | NOV
2017-06-15 00:00:00 | INACTIVE | 9261 |  |  | DEC |  | DEC
2017-06-20 00:00:00 | INACTIVE | 6591
2017-06-21 00:00:00 | INACTIVE | 7378
2017-06-22 00:00:00 | WON | 6750
2017-06-22 00:00:00 | WON | 5887
2017-06-23 00:00:00 | INACTIVE | 6750
2017-06-26 00:00:00 | WON | 6750
2017-06-28 00:00:00 | INACTIVE | 9956
2017-06-29 00:00:00 | INACTIVE | 16188
2017-07-10 00:00:00 | WON | 6215
2017-07-11 00:00:00 | LOST | 6591
2017-08-14 00:00:00 | WON | 8128
2017-08-29 00:00:00 | WON | 7378
2018-01-24 00:00:00 | WON | 6750
2018-02-15 00:00:00 | WON | 12995
2018-02-22 00:00:00 | WON | 9913
2018-03-05 00:00:00 | INACTIVE | 50000
2018-03-22 00:00:00 | WON | 14535
2018-04-13 00:00:00 | WON | 9421
2018-04-13 00:00:00 | WON | 6928
2018-06-25 00:00:00 | WON | 9261
2018-07-20 00:00:00 | WON | 8865
2018-07-24 00:00:00 | WON | 9261
2018-08-09 00:00:00 | WON | 9400
2018-08-29 00:00:00 | WON | 33400
2018-09-08 00:00:00 | WON | 9495
2018-09-08 00:00:00 | WON | 6750
2018-09-08 00:00:00 | WON | 24148.05
2018-09-26 00:00:00 | INACTIVE | 9600
2018-09-27 00:00:00 | INACTIVE | 59000
2018-09-27 00:00:00 | INACTIVE | 5900
2018-09-28 00:00:00 | WON | 46339
2018-10-03 00:00:00 | INACTIVE | 28000
2018-10-05 00:00:00 | WON | 121054
2018-10-16 00:00:00 | INACTIVE | 16600
2018-10-19 00:00:00 | INACTIVE | 41000
2018-10-22 00:00:00 | LOST | 41000
2018-10-25 00:00:00 | WON | 9495
2018-11-20 00:00:00 | WON | 5962
2018-11-20 00:00:00 | WON | 10669
2018-12-10 00:00:00 | INACTIVE | 1900
2018-12-17 00:00:00 | WON | 6594
2019-03-01 00:00:00 | WON | 7146
2019-03-15 00:00:00 | WON | 10708
2019-03-27 00:00:00 | WON | 17628
2019-04-04 00:00:00 | WON | 11695
2019-04-16 00:00:00 | WON | 33039
2019-04-16 00:00:00 | WON | 7600
2019-04-19 00:00:00 | WON | 15990
2019-05-20 00:00:00 | WON | 6100
2019-06-18 00:00:00 | WON | 11988
2019-06-21 00:00:00 | WON | 7685
2019-06-24 00:00:00 | WON | 49169
2019-08-22 00:00:00 | WON | 36190
2019-09-04 00:00:00 | WON | 7800
2019-09-12 00:00:00 | WON | 19965
2019-09-19 00:00:00 | WON | 6574
2019-10-07 00:00:00 | WON | 4468
2019-10-28 00:00:00 | WON | 9490
2019-10-28 00:00:00 | WON | 6590
2019-12-16 00:00:00 | WON | 6590
2020-01-15 00:00:00 | WON | 7800
2020-03-05 00:00:00 | WON | 7800
2020-03-06 00:00:00 | WON | 7808
2020-03-13 00:00:00 | WON | 6600
2020-03-30 00:00:00 | WON | 23886
2020-04-02 00:00:00 | WON | $8,000 *
2020-04-29 00:00:00 | WON | 6434.32
2020-05-22 00:00:00 | WON | 11725
2020-08-17 00:00:00 | WON | 7995
2020-08-17 00:00:00 | WON | 6400
2020-08-24 00:00:00 | WON | 37000
2020-09-23 00:00:00 | WON | 7995
2020-09-23 00:00:00 | WON | 13030
2020-10-09 00:00:00 | WON | 5925
2020-11-09 00:00:00 | INACTIVE | 35000
2020-11-25 00:00:00 | INACTIVE | 18500
2020-12-03 00:00:00 | INACTIVE | 7995
2020-12-04 00:00:00 | WON | 9750
2020-12-07 00:00:00 | INACTIVE | 6600
2020-12-07 00:00:00 | INACTIVE | 10280
2020-12-09 00:00:00 | WON | 15600
2020-12-10 00:00:00 | WON | 38900
2020-12-14 00:00:00 | INACTIVE | 5960
2021-01-04 00:00:00 | INACTIVE | 6100
2021-01-04 00:00:00 | INACTIVE | 6100
2021-01-07 00:00:00 | INACTIVE | 31800
2021-01-08 00:00:00 | INACTIVE | 5595
2021-01-11 00:00:00 | WON | 5990
2021-01-11 00:00:00 | WON | 9300
2021-01-23 00:00:00 | WON | 9157
2021-02-08 00:00:00 | WON | 5965
2021-02-17 00:00:00 | WON | 6100
2021-03-04 00:00:00 | WON | 23400
2021-03-10 00:00:00 | WON | 7995
2021-03-31 00:00:00 | WON | 7800
2021-04-06 00:00:00 | WON | 7800
2021-04-07 00:00:00 | WON | 26450
2021-04-19 00:00:00 | WON | 6100
2021-05-25 00:00:00 | WON | 6600
2021-06-21 00:00:00 | WON | 6100
2021-07-03 00:00:00 | WON | 16330
2021-07-28 00:00:00 | WON | 6744
2021-07-29 00:00:00 | WON | 7995
2021-07-30 00:00:00 | WON | 12387
2021-08-13 00:00:00 | WON | 6900
2021-08-26 00:00:00 | INACTIVE | 30000
2021-08-30 00:00:00 | INACTIVE | 6600
2021-08-31 00:00:00 | WON | 6600
2021-09-21 00:00:00 | WON | 20820
2021-09-21 00:00:00 | WON | 12450
2021-09-22 00:00:00 | WON | 38768
2021-09-23 00:00:00 | WON | 7995
2021-11-16 00:00:00 | WON | 21384
2021-11-23 00:00:00 | WON | 9312
2021-11-26 00:00:00 | WON | 30065
2021-12-08 00:00:00 | WON | 21100
2021-12-10 00:00:00 | WON | 133920
2022-01-06 00:00:00 | WON | 7800
2022-02-25 00:00:00 | WON | 20375
2022-03-02 00:00:00 | WON | 56000
2022-03-15 00:00:00 | WON | 10200
2022-03-24 00:00:00 | WON | 16330
2022-04-15 00:00:00 | WON | 6600
2022-04-20 00:00:00 | WON | 18785
2022-04-30 00:00:00 | WON | 5990
2022-05-19 00:00:00 | WON | 7800
2022-05-25 00:00:00 | WON | 6600
2022-05-25 00:00:00 | WON | 6600
2022-06-08 00:00:00 | WON | 66671
2022-06-14 00:00:00 | WON | 9795
2022-06-15 00:00:00 | WON | 243400
2022-06-20 00:00:00 | WON | 38700
2022-06-23 00:00:00 | WON | 6600
2022-07-07 00:00:00 | WON | 6300
2022-08-01 00:00:00 | WON | 6600
2022-09-05 00:00:00 | WON | 6600
2022-10-01 00:00:00 | WON | 6635
2022-10-14 00:00:00 | WON | 6600
2022-10-17 00:00:00 | WON | 6600
2022-10-18 00:00:00 | WON | 6600
2022-10-20 00:00:00 | WON | 6600
2022-10-21 00:00:00 | WON | 13700
2022-11-08 00:00:00 | WON | 6600
2022-11-16 00:00:00 | WON | 31900
2022-11-24 00:00:00 | WON | 6600
2022-11-29 00:00:00 | WON | 13200
2022-12-05 00:00:00 | WON | 7800
2022-12-08 00:00:00 | WON | 9000
2022-12-16 00:00:00 | WON | 10225
2022-12-16 00:00:00 | WON | 31203
2022-12-16 00:00:00 | WON | 13350
2023-01-05 00:00:00 | WON | 6600
2023-01-09 00:00:00 | LOST | 32000
2023-01-11 00:00:00 | INACTIVE | 13800
2023-01-11 00:00:00 | INACTIVE | 52000
2023-01-12 00:00:00 | WON | 18700
2023-01-13 00:00:00 | INACTIVE | 39900
2023-01-13 00:00:00 | INACTIVE | 52400
2023-01-16 00:00:00 | WON | 39900
2023-01-18 00:00:00 | WON | 7000
2023-01-24 00:00:00 | INACTIVE | 34300
2023-01-24 00:00:00 | INACTIVE | 7000
2023-02-02 00:00:00 | INACTIVE | 13000
2023-02-07 00:00:00 | INACTIVE | 18800
2023-02-07 00:00:00 | WON | 177200
2023-02-10 00:00:00 | INACTIVE | 32200
2023-02-11 00:00:00 | WON | 6600
2023-02-16 00:00:00 | INACTIVE | 7000
2023-02-20 00:00:00 | WON | 13000
2023-02-22 00:00:00 | INACTIVE | 14000
2023-02-22 00:00:00 | INACTIVE | 13000
2023-02-23 00:00:00 | WON | 6600
2023-02-24 00:00:00 | INACTIVE | 7000
2023-02-24 00:00:00 | WON | 6950
2023-02-27 00:00:00 | WON | 30000
2023-03-07 00:00:00 | WON | 6950
2023-03-08 00:00:00 | INACTIVE | 16300
2023-03-08 00:00:00 | WON | 232000
2023-03-08 00:00:00 | WON | 8200
2023-03-08 00:00:00 | WON | 7450
2023-03-08 00:00:00 | WON | 35700
2023-03-10 00:00:00 | LOST | 10000
2023-03-10 00:00:00 | WON | 6600
2023-03-10 00:00:00 | INACTIVE | 6600
2023-03-16 00:00:00 | WON | 6600
2023-03-22 00:00:00 | INACTIVE | 30000
2023-03-28 00:00:00 | INACTIVE | 6950
2023-03-31 00:00:00 | INACTIVE | 6950
2023-04-04 00:00:00 | INACTIVE | 6950
2023-04-04 00:00:00 | INACTIVE | 16330
2023-04-10 00:00:00 | INACTIVE | 21000
2023-04-14 00:00:00 | INACTIVE | 8000
2023-04-14 00:00:00 | INACTIVE | 6950
2023-04-17 00:00:00 | INACTIVE | 6950
2023-04-19 00:00:00 | INACTIVE | 6950
2023-05-05 00:00:00 | INACTIVE | 6950
2023-05-08 00:00:00 | WON | 7750
2023-05-12 00:00:00 | WON | 30100
2023-05-12 00:00:00 | INACTIVE | 6200
2023-05-15 00:00:00 | INACTIVE | 35760
2023-05-19 00:00:00 | WON | 18130
2023-05-29 00:00:00 | LOST | 67200
2023-05-31 00:00:00 | WON | 18750
2023-06-02 00:00:00 | WON | 8290
2023-06-02 00:00:00 | INACTIVE | 13800
2023-06-05 00:00:00 | WON | 8290
2023-06-07 00:00:00 | WON | 9650
2023-06-09 00:00:00 | INACTIVE | 6950
2023-06-12 00:00:00 | WON | 27536
2023-06-13 00:00:00 | WON | 36000
2023-06-15 00:00:00 | LOST | 6950
2023-06-20 00:00:00 | INACTIVE | 6950
2023-06-25 00:00:00 | WON | 8800
2023-06-26 00:00:00 | INACTIVE | 6950
2023-06-27 00:00:00 | INACTIVE | 8300
2023-07-10 00:00:00 | WON | 8385
2023-07-13 00:00:00 | INACTIVE | 7300
2023-07-16 00:00:00 | INACTIVE | 10200
2023-07-17 00:00:00 | WON | 9325
2023-07-17 00:00:00 | LOST | 30000
2023-07-18 00:00:00 | WON | 67200
2023-07-19 00:00:00 | INACTIVE | 184000
2023-07-19 00:00:00 | INACTIVE | 9650
2023-07-21 00:00:00 | WON | 6950
2023-07-31 00:00:00 | INACTIVE | 9850
2023-08-01 00:00:00 | WON | 32660
2023-08-03 00:00:00 | INACTIVE | 9650
2023-08-07 00:00:00 | LOST | 6950
2023-08-14 00:00:00 | WON | 6950
2023-08-16 00:00:00 | INACTIVE | 6950
2023-08-21 00:00:00 | WON | 21045
2023-08-22 00:00:00 | LOST | 10200
2023-08-24 00:00:00 | INACTIVE | 8385
2023-08-31 00:00:00 | INACTIVE | 18795
2023-09-06 00:00:00 | WON | 8300
2023-09-06 00:00:00 | INACTIVE | 9650
2023-09-08 00:00:00 | INACTIVE | 6950
2023-09-12 00:00:00 | WON | 6950
2023-09-12 00:00:00 | INACTIVE | 9850
2023-09-12 00:00:00 | INACTIVE | 13780
2023-09-14 00:00:00 | WON | 9700
2023-09-14 00:00:00 | INACTIVE | 6300
2023-09-19 00:00:00 | INACTIVE | 6950
2023-09-19 00:00:00 | WON | 6950
2023-09-19 00:00:00 | WON | 9835
2023-09-26 00:00:00 | INACTIVE | 15581
2023-09-28 00:00:00 | INACTIVE | 7300
2023-10-03 00:00:00 | INACTIVE | 18795
2023-10-04 00:00:00 | WON | 19808
2023-10-06 00:00:00 | INACTIVE | 18729
2023-10-18 00:00:00 | INACTIVE | 9535
2023-10-26 00:00:00 | LOST | 6950
2023-11-03 00:00:00 | WON | 16330
2023-11-16 00:00:00 | WON | 7400
2023-11-16 00:00:00 | WON | 12132
2023-11-17 00:00:00 | INACTIVE | 6950
2023-11-21 00:00:00 | INACTIVE | 8150
2023-11-22 00:00:00 | INACTIVE | 6950
2023-11-29 00:00:00 | INACTIVE | 39900
2024-01-03 00:00:00 | INACTIVE | 8300
2024-01-04 00:00:00 | WON | 15581
2024-01-05 00:00:00 | WON | 18750
2024-01-08 00:00:00 | WON | 10230
2024-01-09 00:00:00 | INACTIVE | 6950
2024-01-09 00:00:00 | INACTIVE | 6950
2024-01-09 00:00:00 | INACTIVE | 6950
2024-01-11 00:00:00 | WON | 6950
2024-01-11 00:00:00 | INACTIVE | 6950
2024-01-15 00:00:00 | INACTIVE | 6950
2024-01-16 00:00:00 | WON | 7290
2024-01-19 00:00:00 | ACTIVE | 22210
2024-01-22 00:00:00 | ACTIVE | 45000
2024-01-23 00:00:00 | ACTIVE | 13900
2024-01-23 00:00:00 | ACTIVE | 6950
2024-01-23 00:00:00 | WON | 6950
2024-01-23 00:00:00 | ACTIVE | 6950
2024-01-24 00:00:00 | ACTIVE | 9850
2024-01-30 00:00:00 | WON | 133700
2024-02-01 00:00:00 | WON | 2200
2024-02-01 00:00:00 | ACTIVE | 6950
2024-02-01 00:00:00 | WON | 600
2024-02-05 00:00:00 | LOST | 8300
2024-02-20 00:00:00 | ACTIVE | 8300
2024-02-21 00:00:00 | WON | 400
2024-02-21 00:00:00 | ACTIVE | 12600
2024-02-22 00:00:00 | WON | 56000
2024-02-26 00:00:00 | WON | 23517
2024-02-27 00:00:00 | ACTIVE | 4500
2024-03-01 00:00:00 | ACTIVE | 6950
2024-03-14 00:00:00 | ACTIVE | 21820
2024-03-14 00:00:00 | ACTIVE | 18720
2024-03-14 00:00:00 | ACTIVE | 75
2024-03-18 00:00:00 | WON | 14580