Formula for column sum this month

Hello!

I want to make a sheet summary formula to calculate the sum from a single column just within the current month. I've attached a screenshot of the columns I'm working with. Thank you very much in advance!

• ✭✭✭✭✭✭

Give this a try:

=SUMIFS([Newborn Report Items Completed]:[Newborn Report Items Completed], [Date]:[Date], MONTH(@cell) = MONTH(TODAY()), [Date]:[Date], YEAR(@cell) = YEAR(TODAY()))

• ✭✭✭✭✭✭

It looks as if the column names in the formula do not match the column names in the sheet. It is possible there could be a hidden space somewhere in a column name.

When creating a [Column Name]:[Column Name] range, I like to click and drag across a few cells within the column to get it to automatically create the range for those couple of rows within that column then just delete the row numbers to get it to reference the entire column. This ensures I definitely have the column names right in my formula.

• ✭✭✭✭✭✭

Give this a try:

=SUMIFS([Newborn Report Items Completed]:[Newborn Report Items Completed], [Date]:[Date], MONTH(@cell) = MONTH(TODAY()), [Date]:[Date], YEAR(@cell) = YEAR(TODAY()))

• @Carson Penticuff It's giving me an #unparsable message :(

• ✭✭✭✭✭✭

Are you able to provide a screenshot of the formula open in the sheet as if you are about to edit it?

• ✭✭✭✭✭✭

It looks as if the column names in the formula do not match the column names in the sheet. It is possible there could be a hidden space somewhere in a column name.

When creating a [Column Name]:[Column Name] range, I like to click and drag across a few cells within the column to get it to automatically create the range for those couple of rows within that column then just delete the row numbers to get it to reference the entire column. This ensures I definitely have the column names right in my formula.

• It worked! Thank you!

• ✭✭✭✭✭✭

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!