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
Please help with formula - sum with a data range filter	3	236	February 12, 2024
How to lookup and sum values of another column?	5	1113	December 25, 2022
Sumif using two variables?	11	2691	October 19, 2019
Count/sum/avg values based on the date range control	4	291	December 29, 2023
Dates within a sum formula	2	689	May 25, 2020

SUMIf date is between [daterange controller]

Related topics