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
=(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...