Forum Discussion
Solved
xlookup and sum within date range
Hello, My input data is like this. i am trying to get an output like this. summed up values in that particular date range. Please guide me. (The same sample d...
KalyanPrasad Perhaps something along these lines for Summary 1:
=SUMIFS(XLOOKUP([@Report], Table1[#Headers], Table1), Table1[Date], ">="&$F$3, Table1[Date], "<="&$G$3)Also, if you position the Start and End Dates above the summary table in rows 1 and 2, you can use relative column / fixed row references so the formula can be copied across the summary columns. See attached...
The solutions all we discussed are based on date range filtering.
What if i want to simply write a month name in header and get the sum of those values in the date table?
something like this.
what would the formula be for this one ?
data sheet attached.
thank you.
Kalyan
KalyanPrasad Same idea as before, but with EOMONTH to convert the header dates:
=SUMIFS(XLOOKUP([@Report], Table1[#Headers], Table1), Table1[Date], ">"&EOMONTH(B$1, -1), Table1[Date], "<="&EOMONTH(B$1, 0))
See attached...
- thank you. this seems intelligent.