Apr 06 2019 03:29 PM
hi,
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:
=sum.if(c2:c9;<"now()";D2:d9).
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.
Lex
Apr 06 2019 03:54 PM
Solution@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.
Apr 07 2019 01:02 AM
Apr 06 2019 03:54 PM
Solution@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.