• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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?



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