SUMIF contents of column F=CHAD and column H has DATA

**chad1207** · 06-20-2013, 08:02 PM

Hello all! I have the attached workbook that I'm working on and hoping someone can help me create a formula for the 3 cells that are highlighted in yellow. I thought it would be easier to attach the spreadsheet instead of explaining what I was hoping to do. Basically I want to sum column E if "chad" is in column F and "no data" is in column H and enter the value in M3. Then sum column E if "chad" is in column F and "the date" is entered in column H and enter the value in N3.

Then I would do the same for P3-Q3 & S3-T3

Hope this explains it well enough.

Thank you in advance!

**benishiryo** · 06-20-2013, 08:56 PM

hi Chad1207, welcome to the forum. try this in M3:
=SUMIFS($E:$E,$F:$F,LEFT(M2,FIND(" ",M2)-1),$H:$H,"=")

this in N3:
=SUMIFS($E:$E,$F:$F,LEFT(N2,FIND(" ",N2)-1),$H:$H,"<>")

copy the 2 formulas & paste to other 4 cells. i'm assuming the name is only a single word & before the 1st space. if it's not true for your real scenario, fix it to this:
=SUMIFS($E:$E,$F:$F,M2,$H:$H,"=")