CONDITONAL SUM DATE RANGE ISSUE

I was asking ooophelia because her formula wouldn't work since your
formula need more criteria than just the date range which her formula would
have worked for

--


Regards,


Peo Sjoblom

"woody" wrote in message
...
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))