I have having issues with this when I try to SUM all the cells that meet that condition.

=IF(LEFT(B2:B71,1)="H",SUM(C2:C71),"ERROR")

See the attached spreadsheet. I also have 3 goals I am trying to do that are explained on the spreadsheet. Can you help me with those formulas?