SumIf Date Range

Options
brbradle
brbradle ✭✭
edited 01/12/23 in Formulas and Functions

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"

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @brbradle

    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.

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @brbradle

    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.

  • brbradle
    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!