In column A I have List of names and column G I have areas.
Column A
Pavement Concrete
Pavement Concrete Sidewalk
Pavement Concrete Pervious
Building
Standard
I would like to add all the areas except for pervious. Having a hard time figuring it out.
Thank you for the help!
Column A
Pavement Concrete
Pavement Concrete Sidewalk
Pavement Concrete Pervious
Building
Standard
Code:
=(SUMIF($A$12:$A$209,"PAVEMENT *",$G$12:$G$209))+(SUMIF($A$12:$A$209,"*BUILDING*",$G$12:$G$209))+(SUMIF($A$12:$A$209,"PROPOSED POND ",$G$12:$G$209))+(SUMIF($A$12:$A$209,"Standard ",$G$12:$G$209)
I would like to add all the areas except for pervious. Having a hard time figuring it out.
Thank you for the help!