How to sumif formula plus criteria of column to omit certain cells.

[EQUILIBRIUM89]

Hello All,

I love this forum learned a lot from here. I am stuck on a problem and was wondering if anyone can help. I have a table with 2 criteria that i am using a sumifs formula. I've also created another " zero check" column in the table to read 0 if row needs to be omitted and ""false" if rows need to be summed. Currently I have not incorporated the "zero check" column into my sumifs formula.

My sumifs formula currently reads as : SUMIFS($H$8:$H$489,$E$8:$E$489,$S13,$B$8:$B$489,$T13)

My check zero formula is in column Q and I would want to add the additional criteria to the H range.

Any help would be appreciated.

 

[Oscar Cronquist]

SUMIFS($H$8:$H$489,$E$8:$E$489,$S13,$B$8:$B$489,$T13,$Q$8:$Q$489, "false")

 

[EQUILIBRIUM89]

Good Morning,

Good thinking...but when I put in the "false" criteria, the formula is returning zero.