Unfortunately no, b/c it should only be adding up occurances that happened
between 90 days after the date in column A and within 6 months from TODAY().

Pete, I don't know if you remember this or not, but you pretty much put this
together for me about 6 months ago. Again, any help you or anyone else can
offer is appreciated. Thanks again.

"Pete_UK" wrote:

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