summing up figures

[Guest]

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.

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Don Guillett]

Have a look at the SUMIF and COUNTIF functions in help index