Hi everyone,
Hoping someone can help me with a formula that is confusing me a bit. I'm trying to write a SUMIF Type function if the corresponding cell in column X is blank. (Or does not equal Yes - either works for me).
In Column F there are numbers, and I want to sum these numbers if column X does not equal Yes. If it does equal yes, it should not sum the hours (hope that makes sense). I provided a screenshot below. Can someone help me with how that would look in excel?
Bookmarks