Sumifs or Sumif or do I need an AND?

[Pumpk1n]

I want to sum certain values in Column H when the following holds true--Column F must <>0 and Column G Must =0. For example, h3=0 and F3>0,te I want to include the value in H3. My formula isn't working. I currently have "=sumifs(h3:h246,F3:F246,>0,g3:G246,=0) but there's an error with the formula. Do I need an "and" Or what is causing the issue.

 

[Joe4]

You need to surround your conditions in double-quotes, i.e.

=SUMIFS(H3:H246,F3:F246,">0",G3:G246,"=0")