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

--
Don Guillett
SalesAid Software

"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