I'm trying to build a table with dates in column C and values (money) in column D.
I want to count the sum of the values in column D it the date in the same row in column C is smaller then the present date.
The formula I made looks like this:
But the total sum does not show up. It stays zero.
Actually I am using the Dutch equivalent of this formula, but that should not make a difference, I think.
Is it possible to compare dates in the sum.if-formula, or am I doing something wrong?
I hope someone can help me.
View best response
@Lex_Albers , it's like
=sum.if(c2:c9;"<" & TODAY();D2:d9)
Better to use TODAY() (if the function has the same name in your locale), it returns date only. NOW() returns date and time.