SUMIF using Dates
 

Hi,

I want to be able to do a SUMIF where the criteria is that the values should
be less than a date (stored in column A). Although I can get the SUMIF
expression to work if a explicitly insert the date (e.g.
SUMIF(.....,"<11/09/06",.....), if I insert and expression (e.g.
SUMIF(.....,"<(A95+7)",.....) - where A95 contains the date value for
04/09/06 - it produces the wrong result.

Can anyone point out where I am going wrong?

SUMIF using Dates
 

=SUMIF(...,"<"&A95+7,...)

HTH
--
AP

"Mike McLellan" a écrit dans le
message de news: ...
Hi,

I want to be able to do a SUMIF where the criteria is that the values
should
be less than a date (stored in column A). Although I can get the SUMIF
expression to work if a explicitly insert the date (e.g.
SUMIF(.....,"<11/09/06",.....), if I insert and expression (e.g.
SUMIF(.....,"<(A95+7)",.....) - where A95 contains the date value for
04/09/06 - it produces the wrong result.

Can anyone point out where I am going wrong?

SUMIF using Dates
 

"Mike McLellan" wrote...
Hi,
I want to be able to do a SUMIF where the criteria is that the values
should
be less than a date (stored in column A). Although I can get the SUMIF
expression to work if a explicitly insert the date (e.g.
SUMIF(.....,"<11/09/06",.....), if I insert and expression (e.g.
SUMIF(.....,"<(A95+7)",.....) - where A95 contains the date value for
04/09/06 - it produces the wrong result.
Can anyone point out where I am going wrong?

Hi!

Try it like this:

SUMIF(.....,"<"&A95+7,.....)

Biff

SUMIF using Dates
 

Mike,

=SUMIF(......,"<" & A95+7,....)

HTH

"Mike McLellan" wrote:

Hi,

I want to be able to do a SUMIF where the criteria is that the values should
be less than a date (stored in column A). Although I can get the SUMIF
expression to work if a explicitly insert the date (e.g.
SUMIF(.....,"<11/09/06",.....), if I insert and expression (e.g.
SUMIF(.....,"<(A95+7)",.....) - where A95 contains the date value for
04/09/06 - it produces the wrong result.

Can anyone point out where I am going wrong?