DSUM where criteria is Current Date

[Magerator]

Hello,

I need to get sum of values based on current date criteria.
TO get sum for values where date is smaller that today's date.

This is overdues report.

I've tried with DSUM and SUMIF but nothing seem to work.

DSUM works like this : =DSUM(Details!A:N;"maksamatta";C34:C35)

where in cell C35 is the current date written "<8.6.2011"
But I sure as hell don't want to change everyday a current date on to that field.

How can I get it like this :

DSUM(Details!A:N;"maksamatta";<now())

Thanks a lot,

Magerator

[Magerator]

Okay got this solved from another forum.

I tried this and it didn't work :
=SUMIF(Details!G:G;<NOW();Details!E:E)

the solution was this :
=SUMIF(Details!G:G;"<"&NOW();Details!E:E)

Simple but took half of my day...

Thank you anyways.

Magerator

[Roger Govier]

Hi

I know you say you have solved your problem, but I would advise against using NOW() as your criterion, unless the data in column G is formatted with time as well as date.

IMO you would be bteer to use =TODAY() rather than NOW()

Also, for your DSUM to work, you could just enter in cell C35 =TODAY() formatted however you wish.