On Nov 3, 3:18 pm, hmsawyer
wrote:
It should only be adding up occurances that happened between
90 days after the date in column A and within 6 months from
TODAY().

Does the following work for you?

=sumproduct(--(D3:IS3 $A3+90), --(D3:IS3 = edate(today(), -6)),
F3:IU3)

EDATE is in the Analysis ToolPak. Use Excel Help for instructions
about how to install it if you get a #NAME error.

If you do not want to use EDATE, you could use:

date(year(today()), month(today())-6, day(today()))

(I would prefer to put =TODAY() into a helper cell.)

But I don't know if the DATE expression will work the way you want if
today's day is 29, 30 or 31 and the month is Aug 2009, for example.