# SumIf Date Range

Options
✭✭
edited 01/12/23

Hi All! I'm trying to use the Summary in a sheet to tabulate an object count between a date range.

I'm trying to get a Sum of cells in a column "Number of Objects", if the "Date Imported" is between a range, 09/01/21- 08/31/22. The formula I'm using is returning "0". The formula is :

=SUMIF([Date Imported]:[Date Imported], AND(@cell < DATE(2021, 9, 1), @cell > DATE(2022, 8, 31)), [Number of Objects]:[Number of Objects])

Does the format of the date matter? Current format is "04/06/22 1:18 PM"

• ✭✭✭✭✭✭
Options

Your formula is trying to find a cell with a date that's less than Sept 1st 2021 and greater than August 31st 2022. That's not possible. I think you just need to reverse the greater than and less than symbols in your formula so it's looking for something that's greater than Sept 1st 2021 but less than August 31st 2022.

• ✭✭✭✭✭✭
Options

Your formula is trying to find a cell with a date that's less than Sept 1st 2021 and greater than August 31st 2022. That's not possible. I think you just need to reverse the greater than and less than symbols in your formula so it's looking for something that's greater than Sept 1st 2021 but less than August 31st 2022.

• ✭✭
Options

@mike TV Ha! Thank You! I missed that!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!