Spreadsheet: 771819d1646860902-make-a-new-table-but-removing-all-the-rows-that-have-a-zero-value-in-a-column-example-done-2
Sheet: Invoice

Residential Total:
Sum 1: |  |  | 250 | $50 charge | $50 charge | $50/revision
Project ID # | Due | Notes | Initial Design Date | [NAME]? | Complex? | # of Revisions | Final Design Date
 | 50 | Revisions (2/11) | 2021-08-03 00:00:00 |  | X | 1 | 2021-09-22 00:00:00 |  |  | 43771 | 50 | Revisions (2/11) | 2021-08-03 00:00:00 |  | X | 1 | 2021-09-22 00:00:00
44931 | 100 | CO + Revisions (3/7) | 2021-08-03 00:00:00 | X |  | 1 | 2021-11-25 00:00:00 |  |  | 44931 | 100 | CO + Revisions (3/7) | 2021-08-03 00:00:00 | X |  | 1 | 2021-11-25 00:00:00
45029 | 50 | Revisions (1/12) + (3/3) | 2021-08-06 00:00:00 |  |  | 2 | 2021-11-22 00:00:00
44270 | 100 | [NAME] (11/11) + (1/12) + (1/27) + (2/8) + (2/10) | 2021-08-14 00:00:00 | X | X | 5 | 2021-09-08 00:00:00
45148 | 50 | [NAME] (10/20) Revisions (2/28) | 2021-08-27 00:00:00 |  |  | 2
44355 | 50 | Revisions (2/4) + (2/15) | 2021-09-14 00:00:00 | X | X | 2 | 2022-02-02 00:00:00
45305 | 50 | Revisions (2/18) | 2021-10-07 00:00:00 |  |  | 1
44073 | 50 | Revisions (2/25) | 2021-10-15 00:00:00 |  |  | 1 | 2022-02-07 00:00:00
45189 | 50 | Revisions (2/15) | 2021-10-19 00:00:00 |  |  | 1 | 2022-02-08 00:00:00
45465 | 50 | Revisions (2/24) | 2021-10-29 00:00:00 | X |  | 1
45093 | 50 | Revisions (2/24) | 2021-11-02 00:00:00 | X |  | 1 | 2022-01-26 00:00:00
45421 | 100 | Revisions (2/25) | 2021-11-02 00:00:00 |  | X | 2
45523 | 50 | Revisions (2/24) | 2021-11-02 00:00:00 | X |  | 1 | 2022-02-02 00:00:00
45216 | 50 | Revisions (2/25) | 2021-11-08 00:00:00 |  |  | 1 | 2022-02-07 00:00:00
45520 | 50 | Revisions (2/28) | 2021-11-08 00:00:00 |  |  | 1
15050 | 100 | Revisions (1/18) + (2/8) + (2/21) | 2021-11-08 00:00:00 |  |  | 3 | 2021-11-25 00:00:00
45321 | 50 | Revisions (2/28) | 2021-11-08 00:00:00 |  |  | 1
45384 | 50 | CO (2/28) | 2021-11-11 00:00:00 |  |  | 1
45344 | 100 | CO & revisions (2/21) | 2021-11-19 00:00:00 | X | X | 1 | 2022-01-26 00:00:00
45280 | 50 | CO (2/3) + (2/15) | 2021-11-22 00:00:00 |  |  | 2
43316 | 50 | [NAME] fit options (12/21) CO (2/11) | 2021-11-25 00:00:00 |  | x | 1 | 2022-02-11 00:00:00
45672 | 50 | Revisions (2/28) | 2021-11-29 00:00:00 |  |  | 1
45560 | 50 | Revisions (2/28) | 2021-12-07 00:00:00 |  |  | 1
45339 | 50 | CO (2/15) | 2021-12-10 00:00:00 |  |  | 1
45152 | 50 | CO (2/10) | 2021-12-15 00:00:00 |  |  | 1
45475 | 50 | CO revisions (3/4) | 2022-01-06 00:00:00 |  |  | 1 | 2022-02-16 00:00:00
45862 | 100 | CO (2/17) | 2022-02-07 00:00:00 | X | X | 1
45060 | 300 |  | 2022-02-08 00:00:00 | X
45834 | 300 |  | 2022-02-09 00:00:00 | X
45925 | 250 |  | 2022-02-09 00:00:00
45920 | 250 |  | 2022-02-09 00:00:00
45684 | 250 |  | 2022-02-09 00:00:00
44193 | 250 |  | 2022-02-11 00:00:00
45849 | 250 |  | 2022-02-11 00:00:00
45797 | 300 |  | 2022-02-11 00:00:00 | X
45954 | 250 |  | 2022-02-15 00:00:00
44869 | 250 |  | 2022-02-15 00:00:00
45839 | 250 |  | 2022-02-15 00:00:00
45649 | 250 |  | 2022-02-15 00:00:00
45963 | 250 |  | 2022-02-15 00:00:00
45745 | 250 |  | 2022-02-16 00:00:00
45880 | 250 |  | 2022-02-16 00:00:00
41755 | 250 |  | 2022-02-17 00:00:00
45978 | 250 |  | 2022-02-18 00:00:00
45603 | 250 |  | 2022-02-18 00:00:00
45766 | 250 |  | 2022-02-18 00:00:00
45953 | 300 |  | 2022-02-18 00:00:00 | X
45778 | 350 |  | 2022-02-18 00:00:00 | X | X
45863 | 300 |  | 2022-02-21 00:00:00 | X
45967 | 300 |  | 2022-02-21 00:00:00 | X
45947 | 300 |  | 2022-02-22 00:00:00 | X
45784 | 250 |  | 2022-02-22 00:00:00
39439 | 250 |  | 2022-02-22 00:00:00
45986 | 350 |  | 2022-02-24 00:00:00 | X | X |  | X
45914 | 250 |  | 2022-02-25 00:00:00
45765 | 400 | Added charges because its COMM project. | 2022-03-03 00:00:00 |  | X | 2
45959 | 250 |  | 2022-03-03 00:00:00
45964 | 250 |  | 2022-03-03 00:00:00
41477 | 250 |  | 2022-03-03 00:00:00
45894 | 300 |  | 2022-03-03 00:00:00 | X
45856 | 250 |  | 2022-03-03 00:00:00
45889 | 250 |  | 2022-03-03 00:00:00
45927 | 250 |  | 2022-03-04 00:00:00
45893 | 250 |  | 2022-03-04 00:00:00
45973 | 250 |  | 2022-03-04 00:00:00
40166 | 300 |  | 2022-03-04 00:00:00 | X
46009 | 250 |  | 2022-03-04 00:00:00
45938 | 250 |  | 2022-03-04 00:00:00
46035 | 250 |  | 2022-03-04 00:00:00
45883 | 250 |  | 2022-03-04 00:00:00
END | END | END | END | END | END | END | END