• 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

    Hui...

  • 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

Member
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?
 

Attachments

  • Sumif.xlsx
    47.6 KB · Views: 2
If you use ">H7" then it's treating H7 as a string, rather than looking at the value of the cell H7.
 
Back
Top