Forum Discussion
gdamir
Feb 05, 2025Copper Contributor
Sumifs with criteria based on time period
Hi.
I have set of values for some time period in the past by days. I want to calculate the values we had before the certain day. I use SUMIFS, but the criteria "<D2" doesn't work. How can I solve it?
Many thanks in advance, Damir
1 Reply
- SergeiBaklanDiamond Contributor
Criteria is
"<" & D2