=SUMIF(D:D,A1,E:E)

where A1 hoilds the date to test for.

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
I am attempting to sub total amounts by month for a fairly large number
of items. I would like to have excel find all instances on one date
(Oct-05 or Jan-06 for example) and report all of the values in the cell
neighboring each (ex, if I am adding the Oct-05 values, I want it to
find the Oct-05 in d-4 and d-8 and report the value for e-4 and e-8).
Once the values are reported, I need the values added . I don't care to
see each value but I do need the total to be seen.