Invalid Data Type, could it be the Month (@cell)

Hello,

In the sheet summary field (property is Text/Number) I am trying to sum invoice amounts (Column is called Amount) that are submitted each month (Column is called Invoice Date and is a Date column) using this formula but getting Invalid Data Type:

=SUMIF([Invoice Date]1:[Invoice Date]22, MONTH(@cell) = 4, [Amount]1:[Amount]22)

4 = April

What is also strange is the formula will somehow change to this:

=SUMIF([Invoice Date]1:[Invoice Date]22, MONTH(@cell) = 4, Amount1:Amount22)

Any help is much appreciated.

Find more posts tagged with

Accepted answers

All comments

Jeremy C

@lisa.bolger27646 When using the Month() function it requires a date like Month([Invoice Date]1). Trying using it with the example to see if it works, then you can use whichever column has the April date and should be good.

https://help.smartsheet.com/function/month

lisa.bolger27646

Thank you Jeremy C! I'm getting closer. Not exactly sure how to work Invoice Date in with Month(@cell)

I understand that the month function sometimes gives errors. Would IFERROR help?

This formula below works!

=SUMIF(Invoice Date1:Invoice Date11, MONTH(@cell) = 2, Amount1:Amount11)

I would like the formula to look at the entire column and tried this, but it doesn't work:

=SUMIF(Invoice Date:Invoice Date, MONTH(@cell) = 2, Amount:Amount)

Any ideas? I know it's not too complicated but I'm stuck, appreciate your help!

Andrée Starå

Hi @lisa.bolger27646

Try something like this.

=SUMIF([Invoice Date]:[Invoice Date], IFERROR(MONTH(@cell),0) = 2, Amount:Amount)

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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.