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

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?

Screen Shot 2023-01-05 at 8.42.45 AM.png

Find more posts tagged with

Accepted answers

All comments

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"),"")

Screen Shot 2023-01-05 at 2.05.22 PM.png

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.