Can't you just omit the final SUMIF term? i.e.:

=IF($A3="",
0,SUMIF(D3:IS3,"="&DATE(YEAR(TODAY()),MONTH(TODAY ())-6,DAY(TODA*
Y())),F3:IU3))

Hope this helps.

Pete

On Nov 3, 10:20*pm, hmsawyer
wrote:
I have the following formula in place in a spreadsheet and have for the last
6 months. *I just noticed a problem. *

This formula is counting occurrences that have happened in the last 6 months
from TODAY(), but not counting anything that occurred in the first 90 days
from hire date, which is the beginning point in column A. *

Now that some occurrences are 6 months old, the formula is counting those
that occurred in the first 90-days as a negative number. *It should just not
count them at all, just as it did for the first 6 months they were listed on
the spreadsheet. *Help! *Thank you.

=IF($A3="",0,SUMIF(D3:IS3,"="&DATE(YEAR(TODAY()), MONTH(TODAY())-6,DAY(TODA*Y())),F3:IU3)-SUMIF(D3:IS3,"<"&($A3+90),F3:IU3))