Spreadsheet: 771712d1646811657-make-a-new-table-but-removing-all-the-rows-that-have-a-zero-value-in-a-column-example
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) | 44411 | 0 | X | 1 | 44461
44931 | 100 | CO + Revisions (3/7) | 44411 | X | 0 | 1 | 44525
45029 | 50 | Revisions (1/12) + (3/3) | 44414 | 0 | 0 | 2 | 44522
44270 | 100 | [NAME] (11/11) + (1/12) + (1/27) + (2/8) + (2/10) | 44422 | X | X | 5 | 44447
45148 | 50 | [NAME] (10/20) Revisions (2/28) | 44435 | 0 | 0 | 2 | 0
44355 | 50 | Revisions (2/4) + (2/15) | 44453 | X | X | 2 | 44594
45305 | 50 | Revisions (2/18) | 44476 | 0 | 0 | 1 | 0
44073 | 50 | Revisions (2/25) | 44484 | 0 | 0 | 1 | 44599
45189 | 50 | Revisions (2/15) | 44488 | 0 | 0 | 1 | 44600
45465 | 50 | Revisions (2/24) | 44498 | X | 0 | 1 | 0
45093 | 50 | Revisions (2/24) | 44502 | X | 0 | 1 | 44587
45421 | 100 | Revisions (2/25) | 44502 | 0 | X | 2 | 0
45523 | 50 | Revisions (2/24) | 44502 | X | 0 | 1 | 44594
45216 | 50 | Revisions (2/25) | 44508 | 0 | 0 | 1 | 44599
45520 | 50 | Revisions (2/28) | 44508 | 0 | 0 | 1 | 0
15050 | 100 | Revisions (1/18) + (2/8) + (2/21) | 44508 | 0 | 0 | 3 | 44525
45321 | 50 | Revisions (2/28) | 44508 | 0 | 0 | 1 | 0
45384 | 50 | CO (2/28) | 44511 | 0 | 0 | 1 | 0
45344 | 100 | CO & revisions (2/21) | 44519 | X | X | 1 | 44587
45280 | 50 | CO (2/3) + (2/15) | 44522 | 0 | 0 | 2 | 0
43316 | 50 | [NAME] fit options (12/21) CO (2/11) | 44525 | 0 | x | 1 | 44603
45672 | 50 | Revisions (2/28) | 44529 | 0 | 0 | 1 | 0
45560 | 50 | Revisions (2/28) | 44537 | 0 | 0 | 1 | 0
45339 | 50 | CO (2/15) | 44540 | 0 | 0 | 1 | 0
45152 | 50 | CO (2/10) | 44545 | 0 | 0 | 1 | 0
45475 | 50 | CO revisions (3/4) | 44567 | 0 | 0 | 1 | 44608
45862 | 100 | CO (2/17) | 44599 | X | X | 1 | 0
45060 | 300 | 0 | 44600 | X | 0 | 0 | 0
45834 | 300 | 0 | 44601 | X | 0 | 0 | 0
45925 | 250 | 0 | 44601 | 0 | 0 | 0 | 0
45920 | 250 | 0 | 44601 | 0 | 0 | 0 | 0
45684 | 250 | 0 | 44601 | 0 | 0 | 0 | 0
44193 | 250 | 0 | 44603 | 0 | 0 | 0 | 0
45849 | 250 | 0 | 44603 | 0 | 0 | 0 | 0
45797 | 300 | 0 | 44603 | X | 0 | 0 | 0
45954 | 250 | 0 | 44607 | 0 | 0 | 0 | 0
44869 | 250 | 0 | 44607 | 0 | 0 | 0 | 0
45839 | 250 | 0 | 44607 | 0 | 0 | 0 | 0
45649 | 250 | 0 | 44607 | 0 | 0 | 0 | 0
45963 | 250 | 0 | 44607 | 0 | 0 | 0 | 0
45745 | 250 | 0 | 44608 | 0 | 0 | 0 | 0
45880 | 250 | 0 | 44608 | 0 | 0 | 0 | 0
41755 | 250 | 0 | 44609 | 0 | 0 | 0 | 0
45978 | 250 | 0 | 44610 | 0 | 0 | 0 | 0
45603 | 250 | 0 | 44610 | 0 | 0 | 0 | 0
45766 | 250 | 0 | 44610 | 0 | 0 | 0 | 0
45953 | 300 | 0 | 44610 | X | 0 | 0 | 0
45778 | 350 | 0 | 44610 | X | X | 0 | 0
45863 | 300 | 0 | 44613 | X | 0 | 0 | 0
45967 | 300 | 0 | 44613 | X | 0 | 0 | 0
45947 | 300 | 0 | 44614 | X | 0 | 0 | 0
45784 | 250 | 0 | 44614 | 0 | 0 | 0 | 0
39439 | 250 | 0 | 44614 | 0 | 0 | 0 | 0
45986 | 350 | 0 | 44616 | X | X | 0 | X
45914 | 250 | 0 | 44617 | 0 | 0 | 0 | 0
45765 | 400 | Added charges because its COMM project. | 44623 | 0 | X | 2 | 0
45959 | 250 | 0 | 44623 | 0 | 0 | 0 | 0
45964 | 250 | 0 | 44623 | 0 | 0 | 0 | 0
41477 | 250 | 0 | 44623 | 0 | 0 | 0 | 0
45894 | 300 | 0 | 44623 | X | 0 | 0 | 0
45856 | 250 | 0 | 44623 | 0 | 0 | 0 | 0
45889 | 250 | 0 | 44623 | 0 | 0 | 0 | 0
45927 | 250 | 0 | 44624 | 0 | 0 | 0 | 0
45893 | 250 | 0 | 44624 | 0 | 0 | 0 | 0
45973 | 250 | 0 | 44624 | 0 | 0 | 0 | 0
40166 | 300 | 0 | 44624 | X | 0 | 0 | 0
46009 | 250 | 0 | 44624 | 0 | 0 | 0 | 0
45938 | 250 | 0 | 44624 | 0 | 0 | 0 | 0
46035 | 250 | 0 | 44624 | 0 | 0 | 0 | 0
45883 | 250 | 0 | 44624 | 0 | 0 | 0 | 0