How to sum rows only if a data is between a range

[giad]

Hi!
I have an excel with ID and relative dates.
I need to count the total of ID if a Date is between a range…How can I do that?

Thanks
Giada

[elsamuel]

I need to count the total of ID

This is unclear. Do you need a count? Or do you need a sum?

Off the top of my head, I’d suggest using a Row Filter node to isolate the relevant rows, and then a Group By node to aggregate the appropriate column.

[giad]

I need a count of ID (field ID) if the data (field DATE) is between a range (for example between 2016 and 2017…
I have used the node “Date&Time - based Row filter”…But I want to add a condition for example:
between 2017 and 2016 OR 2018 and 2019

How can I do that?
Thanks
Giada

[FtmhRahimi]

Hi @giad
If you first convert the dates (those on which the filter is based) into flow variables, you can use the “Rule Engine” to write your desired conditions.

[ipazin]

Hello @giad,

see this workflow example:

Filter on Date Range – scottf

Br,
Ivan