#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Sum columns for each month

Options
edited 12/09/19

I would like to summarize the cost of each month in the current year. columns for each month and year. I do not get the formula: =SUMIFS([Totalsum eks. mva]29:[Totalsum eks. mva]1403; Start29:Start1403; MONTH(@cell) = [Årlige utførelser]28; YEAR(@cell) = [Måneder for utførsel]28)

Tags:

• Employee
Options

Hello,

The last criteria in your formula is missing the range. Each criteria to search for, needs to have it's own range set. Here's the formula with the range added:

=SUMIFS([Totalsum eks. mva]29:[Totalsum eks. mva]1403; Start29:Start1403; MONTH(@cell) = [Årlige utførelser]28; Start29:Start1403; YEAR(@cell) = [Måneder for utførsel]28)

Here's the help center article on the SUMIF function (https://help.smartsheet.com/function/sumif).

• Options

Thanks for helping.

I still get an #INVALID DATA TYPE error.

Is it possible to share the sheet with you, so you can take a look.

It may be some error in one of the ranges? If its not a valid date in the date coloumn ?

• Employee
Options

Hello,

If there are any blank cells in the date column that this formula is referencing, this could be the cause of the issue. If you'd like the formula to run regardless of blank date cells, it can be changed to this:

=SUMIFS([Totalsum eks. mva]29:[Totalsum eks. mva]1403; Start29:Start1403; IFERROR(MONTH(@cell); 0) = [Årlige utførelser]1; Start29:Start1403; IFERROR(YEAR(@cell); 0) = [Måneder for utførsel]1)

If this doesn't seem to get this working for you, one of our support technicians will be happy to assist further with this. Please contact us through the contact help form here (https://help.smartsheet.com/contact).

This discussion has been closed.