I need a formula that looks at a column and if that column has a "0" input in
it, then add the number in the cell next to it. I have tried -
IF(H5:H70=0,sum(G5:g70,"")).