What is wrong with the next formula? =SOM.ALS(R7:R18;<=vandaag();B7:B18)
C Claus Busch May 3, 2013 #2 Hi Peter, Am Fri, 03 May 2013 13:34:01 +0200 schrieb PeCoNe: What is wrong with the next formula? =SOM.ALS(R7:R18;<=vandaag();B7:B18) Click to expand... try: =SOM.ALS(R7:R18;"<="&vandaag();B7:B18) Regards Claus Busch
Hi Peter, Am Fri, 03 May 2013 13:34:01 +0200 schrieb PeCoNe: What is wrong with the next formula? =SOM.ALS(R7:R18;<=vandaag();B7:B18) Click to expand... try: =SOM.ALS(R7:R18;"<="&vandaag();B7:B18) Regards Claus Busch
P PeCoNe May 3, 2013 #3 Op 2013-05-03 13:42, Claus Busch schreef: Hi Peter, Am Fri, 03 May 2013 13:34:01 +0200 schrieb PeCoNe: try: =SOM.ALS(R7:R18;"<="&vandaag();B7:B18) Regards Claus Busch Click to expand... thanks again Claus. Bye Peter
Op 2013-05-03 13:42, Claus Busch schreef: Hi Peter, Am Fri, 03 May 2013 13:34:01 +0200 schrieb PeCoNe: try: =SOM.ALS(R7:R18;"<="&vandaag();B7:B18) Regards Claus Busch Click to expand... thanks again Claus. Bye Peter