•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
Our take
If you're navigating the complexities of using the SUMIFS function with user-input dates, you’re not alone. The challenge of integrating a named reference for a date can be a significant hurdle in data management. In your case, you're seeking a solution to replace a manually typed date with a user-defined date stored in a cell, thus enhancing flexibility in your spreadsheet. This is a common scenario, and there are effective ways to achieve this.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Is there a way to Sumifs up to a certain column with multiple criteria?Hi everyone, I’m looking for a formula to sum all of the columns starting from a particular column up to a particular column. How do I best do that? On the data tab, Row 1 I have the following columns: A1 = date B1 = serial number C1 = customer name D1 = date 1, with the data being $ E1 = date 2, with the data being $ F1 = date 3, with the data being $ In a separate tab I have the same thing mirroring the data tab, but without the $, for the calculation what I intend to do is on E2, I want to say if $A2 = E$ 1, then sum all of D up to E column on the data tab provided that the value on B column of the data tab match B2 of the calc tab, and C column of the data tab match C2 of the calc tab. For F2, it would be the same thing, but sum column D up to column F instead of column E. I hope it makes sense. Thanks for your help! submitted by /u/botng [link] [comments]
- Sum of a range based on 2 different criteria?Hello, I'm working on a document which is a holiday funds to keep track of individual person's remaining balance to pay. I want to use a formula to automatically calculate the sum of a range of cells which lie against a certain year under a person's name. Below as an example: https://preview.redd.it/1p19n1o8qrxg1.png?width=991&format=png&auto=webp&s=2e67c0337da92ae1feffe43fc2c7fbaba237d672 As above, I want to look up Name 1 in 1:1, look up Year 1 in A:A and then return the sum of those numbers in that Year 1 range to give me my final result. Is this possible? I've tried all sorts of SUM, SUMIF, SUMIFS, XLOOKUP and combinations but can't seem to get it to work. I also don't want to have to manually select the cells for year SUM as this is constantly updating and want it to be automated. Thank you! submitted by /u/celestialspace [link] [comments]