Thread
:
SUMIF using Dates
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ardus Petus
external usenet poster
Posts: 718
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?
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus