Thread: sumif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nuno Jácome
 
Posts: n/a
Default sumif

Could anybody help me on the following problem:
= sumif(C9:C502;"=24-01-2006";L9:L502) - this work, but I want
= sumif(C9:C502;"=Today";L9:L502) or
= sumif(C9:C502;"=G6";L9:L502)
The G6 = Today() or Now()

Thanks in advance