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
Laste date before date	3	919	November 10, 2019
How to lookup and sum values of another column?	5	941	December 25, 2022
Please help with formula - sum with a data range filter	3	172	February 12, 2024
Countif Sum Date Range	3	632	April 10, 2021
How to Sum a column from a different table if the date is within the month defined in current table	5	542	March 13, 2022

SUMIf date is between [daterange controller]

Related topics