Formula Help, Sum by month

swaldon2

Hi I am trying to do a formula that sums that total system size value based on the month in a date column.

=SUMIF({NTP Date}, IFERROR(MONTH(@cell), 0) = 1, {System Size})

Paul Newcome

Double check that the date column is in fact set as a date type. If it is, how exactly is it being populated and how exactly is the range you are summing being populated (and what column type is that)?

Paul Newcome

Are you getting an error message or an inaccurate count? Your syntax looks correct, so we will need more details if you are having an issue.

swaldon2

I keep getting the output of 0 for all months, which I know is incorrect.

Paul Newcome

Double check that the date column is in fact set as a date type. If it is, how exactly is it being populated and how exactly is the range you are summing being populated (and what column type is that)?

swaldon2

The date column was not set as a date! The formula is now working. Thank you!

Paul Newcome

Happy to help. 👍️