formula

[karen]

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?

[Don Guillett]

have a look in HELP index for SUMIF

--
Don Guillett
SalesAid Software
[email protected]
"karen" <[email protected]> wrote in message
news:[email protected]...
> 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?
>