Hi,

I'm using the below SumIf equation, however the range in Column G is a formula and so the sum always comes out to 0.

Is there a way to get the below forumla to only sum the values in H if the formula in G shows a value, and ignore anything cells in G that are blank?

(The formula in Column G is part of a IF equation with a VLOOKUP to a seperate spreadsheet)

=SUMIF(G25:G80,"<1",H25:H80)