Forum Discussion
Misleiloee
May 17, 2023Copper Contributor
Date before another date (cell range) with SUMIFS
Hello, I would like to have the sum of closed topics before or at the targeted closure date. I tried to use SUMIFS but I don’t know how to put those closed before the targeted closure date, becau...
- May 17, 2023
See the attached version.
Misleiloee
May 17, 2023Copper Contributor
I tried but it didn’t work 😞
HansVogelaar
May 17, 2023MVP
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- MisleiloeeMay 17, 2023Copper Contributor
i made an excel sheet with all important columns I have on my actual sheet for better example, https://docs.google.com/file/d/1RE22k-i3E-jicdi0qFujVSqgQ0mWRq7K/edit?usp=docslist_api&filetype=msexcel
- HansVogelaarMay 17, 2023MVP
See the attached version.
- MisleiloeeMay 17, 2023Copper ContributorOhh, so that's how this formula works.
Thank you so much !
Have a great day/night