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...
- Thanks Tejas_shah , but in the report page, if i drag the cell B2 to below column cells B3, B4 & B5, the values are not picking up, instead repeating the same formula. So this is not a complete solution. i need to enter formula for each row individually.
For a complete solution, Should we put a third criteria, that out of the whole data, the column named "so and so" has to be picked up ?
i tried with this formula, but it didnt work for me,
=sumifs(Table1[[opening balance]:[balance]],Table1[#Headers],[@Report],Table1[Date],">="Report!$F$3,Table1[Date],"<="Report!$G$3)
