SUMIF FORMUAL WONT WORK IN COLUMN THAT IS CONVERTED TO A FORMULA

NikkiOno

I am trying to sum the net sales for the current month in my "Daily Sales Activity" sheet IF my helper column says "YES" (this is the current month) but I keep getting INVALID DATA TYPE.

My formula is =SUMIF([CURRENT MONTH HELPER 2]:[CURRENT MONTH HELPER 2], "YES", [Net Sales]:[Net Sales])

i think its because the rest of the column isn't filled out yet and says INVALID DATA TYPE but that wont be filled out until the days go on. How can I fix this?

Samuel Mueller

@NikkiOno put your formula in an iferror statement

=iferror( SUMIF([CURRENT MONTH HELPER 2]:[CURRENT MONTH HELPER 2], "YES", [Net Sales]:[Net Sales]) , "n/a")

Instead of n/a you can put "" to return nothing.

NikkiOno

@Samuel Mueller

It kind of worked. it is returning nothing but should be returning the sum of the current month sales ($15,100).

=IFERROR(SUMIF([CURRENT MONTH HELPER 2]:[CURRENT MONTH HELPER 2], "YES", [Net Sales]:[Net Sales]), "")

Samuel Mueller

@NikkiOno I may have misunderstood your question then. The #invalid at the end of your sheet here would cause your formula to not work. Maybe you need to wrap the formula you have in column month helper 2 in the iferror statement instead to fix these errors.

NikkiOno

@Samuel Mueller that isn't working. =IFERROR(MONTH(TODAY()) = MONTH(Date@row), "YES"),"")

Samuel Mueller

@NikkiOno

=IFERROR(IF(MONTH(TODAY()) = MONTH(Date@row), "YES"),"")

You omitted the "IF"

NikkiOno

@Samuel Mueller ha! well that worked. thanks so much.

Samuel Mueller

Awesome! I would do the same thing for the column next to it as well