Hi, can anyone provide the right column formula to SUMIf rows from another table if its date column is between [daterange controller] ? Preferably using Filter function, because I need to add multiple criteria as well. I tried Matches formula but in each version it returns 0. (Even if I set up a d…

I think this is what you were looking for :slight_smile: For the Price Tasks.Filter([Done date]>=[daterangepicker 1].First() AND [Done date]<=[daterangepicker 1].Last() AND Epic.[Epic Name]=thisRow.[Epic Name]).Price.Sum() And for the Duration Tasks.Filter([Done date]>=[daterangepicker 1].First(…

SUMIf date is between [daterange controller]

mallika November 1, 2019, 7:06pm 4

Can you share a sample doc here and I can work directly in that with you? Thanks !

Topic		Replies	Views
How to lookup and sum values of another column?	5	1065	December 25, 2022
Sumif using two variables?	11	2610	October 19, 2019
Please help with formula - sum with a data range filter	3	202	February 12, 2024
Dates within a sum formula	2	677	May 25, 2020
Hours spent each month	2	643	April 26, 2020

SUMIf date is between [daterange controller]

Related topics