=SUMPRODUCT(--(A2:A20-DAY(A2:A20)+1=--"2005-11-01"),F2:F20)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rich" wrote in message
...
hello again.

i would like to know how i can get excel to sum up figures from a set date
only.

i have column A with the date and column F with transactions values and i
want excel to be able to take only the figure from a certain date and give
me
the figures for just that date.

for example sheet1 is containing figures for whole of november with the
date
in column A i want excel to show on sheet3 a totals for the figures in
column
F under the appropriate date.

thank you.


--
- Rich