V13 is False as text, it is the Code no.

"Peo Sjoblom" wrote:

What about this part?

$B$2:$B$1423=V13

--


Regards,


Peo Sjoblom

"ooophelia" wrote in message
...
Hope this helps. I use date ranges as well, and here's how my formula
works:

(Let column A be the date range you are searching, and B be the result. I
just used an arbitrary date range).

=SUMIF(A1:A10, "=8/4/08", B1:B10)-SUMIF(A1:A10, "8/8/08", B1:B10)

It works like a charm!



"woody" wrote:

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))