I am working on the following formula that returns 0 as the answer but when I
review the formula bar it has the correct answer? Is there anything I can do
to display the result in the cell or am I overwriting the calculation with
the 0 for the false statement somehow. I have changed the grouping but it
does not work.

=SUM(IF(YTD!$B$2:$B$20000=A8,IF(YTD!$A$2:$A$20000 =DATEVALUE("2/01/2008"),IF(YTD!$A$2:$A$20000<DATEVALUE("3/1/2008"),YTD!$F$2:$F$20000,0),0),0))

Thanks