have a look in HELP index for SUMIF

--
Don Guillett
SalesAid Software

"karen" wrote in message
...
if i have a load of date and i want it to be merged together and the
values
added up can it be done .

i,e if i have monday 2hrs ,
tuesday 2hrs,
monday 1 hour,
wednesday 4 hrs,
tuesday 5 hrs .
i would want it to say monday 3 hrs, tuesday 7hrs, wed 4hrs.

any ideas please?