Peo

Came back TRUE,

the cell properties is set to Date.

"Peo Sjoblom" wrote:

If that happens some (maybe all) of your dates are probably text and not
numbers so you are comparing
text with numbers and text is always greater.

Use

=ISTEXT(A2) (I am assuming A2:A4123 are the dates)

copy down and if you get any TRUE values then they are text

do the same for V13 and W13

Post back if you have text values and describe how the dates look
(04/15/2008 etc)

--


Regards,


Peo Sjoblom

"woody" wrote in message
...
Peo,

Thanks for the reply.

I use the conditional sum wizard regularily, but noit with the date range.

I tried making some adjustments and know to use Ctrl + Shift & Enter.
Still
not working.

Tried plugging in your string and still get a zero sum??


"Peo Sjoblom" wrote:

You need to enter the formula with Ctrl + Shift & Enter


You can also rewrite the formula as

=SUMPRODUCT(--($B$2:$B$1423=V13),--($A$2:$A$1423<=W13),--($A$2:$A$1423=X13),$H$2:$H$1423)


and enter it normally

--


Regards,


Peo Sjoblom

"woody" wrote in message
...
Having an issue with suming using the Conditional sum wizard. At the
bottom
is the formula.

Have 3 criteria, a specific code number (shown as V13 below ) and also
fall
between 2 dates, The date criteria is typically like: =1/1/08 &
<=1/31/08
shown as <=W13 and =X13.

The problem is that it always returns zero as the sum and I know its
not
zero.

If I change the date criteria to just =1/1/08 (=X13) it will work but
returns the sum for all the dates equal to or greater than 1/1/08.

Any suggestions would be helpful?

=SUM(IF($B$2:$B$1423=V13,IF($A$2:$A$1423<=W13,IF($ A$2:$A$1423=X13,$H$2:$H$1423,0),0),0))