SUMIFS with multiple criteria and date range

Konrad S.

Hi, I am struggling in getting the following formula to work.

=SUMIFS({P-CARD Range 1}, {P-CARD Range 3}, AND(@cell>=DATE (2025, 1, 1), @cell<=(2025,12, 31)), {P-CARD Range 2}, [15]150)

Range 1 = is a column with dollar values.
Range 3 = is a column with date values.
Range 2 = is a column with specific classification codes. The specific classification code in this instance will be displayed as a static value in cell [15]150.

My issue:
I can not get the following date range syntax to work properly.

AND(@cell>=DATE (2025, 1, 1), @cell<=(2025,12, 31))

or

YEAR (2025)

I need it to pull data only within this date range or a specific year.

Any help is appreciated greatly.

Carson Penticuff

That is certainly possible. Is your date column formatted as DATE? I notice it is right aligned, and date columns default to left aligned unless changed.

Carson Penticuff

Give this a try:

=SUMIFS({P-CARD Range 1}, {P-CARD Range 3}, YEAR(@cell) = 2025, {P-CARD Range 2}, [15]150)

Konrad S.

Hi Carson, thank you for the input. By logic the formula you provided should have worked. I am getting an "Invalid Data Type" error.

Would it be possible that the dates in column Range 3 are not recognized as dates by Smartsheets, but rather some other type values?

Konrad S.

Here is a screenshot of where the data is pulling from (reference sheet location).

Carson Penticuff

That is certainly possible. Is your date column formatted as DATE? I notice it is right aligned, and date columns default to left aligned unless changed.