•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Use Named Reference for Date in SumIfs
Hi all. Looking to see if this is possible, as it's proving to be the final obstacle in me getting something done.
I'm using SumIfs to sum figures based on a few different metrics, one of which is a <=date. It looks like this:
=sumifs(A:A, B:B, 2026, C:C, <DateSelect)
Where DateSelect is a cell in which the user enters a date manually.
The formula works fine when replacing the DateSelect with typing in the actual date into the formula itself like below:
=sumifs(A:A, B:B, 2026, C:C, "<01/02/2026")
But I need the formula to work with the date entered by the user. Is there a way for the formula to work with a named reference?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#formula generator
#financial modeling with spreadsheets
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#cloud-based spreadsheet applications
#Excel alternatives
#SumIfs
#DateSelect
#formula
#Excel
#Excel formula
#date
#metrics
#criteria
#manual entry
#user input