SUMIF not working

[Gregg Wolin]

I cant seem to get sumif to work in a simple formula. I checked the data types and they look OK. I tried countif on the same column and that works. What am i missing?

 

[Fluff13]

What is the G7 meant to be?

 

[Fluff13]

Assuming it should be H7, try
=SUMIF(E13:E372,">"&H7,H13:H372)

 

[Gregg Wolin]

Assuming it should be H7, try
=SUMIF(E13:E372,">"&H7,H13:H372)

Thanks! That did it. Not sure why this syntax was required since H7 is a number.

 

[Fluff13]

If you use ">H7" then it's treating H7 as a string, rather than looking at the value of the cell H7.