SumIf Date Range
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"
Help Article Resources
Check out the Formula Handbook template!