Formula for column sum this month

Lindsay Scarey

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!

Carson Penticuff

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()))

Paul Newcome

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.

Carson Penticuff

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()))

Lindsay Scarey

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

Paul Newcome

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

Lindsay Scarey

@Paul Newcome

Paul Newcome

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.

Lindsay Scarey

It worked! Thank you!

Paul Newcome

Happy to help. 👍️