i need to keep track of volunteer hours for 15 people and make it.

i keep track of volunteer hours. each month i must post hours and need to
have them accumulate..in other workds..if they volunteered 3 hours in october
and 3 in november, in need the total to automatically read 6 hours
total...how do i get started? what chart do i use?

In columns A , B,C keep a record of the volunteers. The month is optional
but if you keep the names in column A it will be easier. For example
Volunteer Month Hours row 1
Mabel Jones Oct 3 row 2
Fred Smith Oct 5
....
Mabel Jones Nov 10
etc

In column F enter a list of all volunteers (alphabetical order if you wish)
In G2 enter formula
Volunteer Hours
Ann Atwood =SUMIF(A:A,F2,C:C) this is formula in G2, copy it down the
column)
Beth Bush


I would think a Column chart would work.
Contact me by private email for more help

best wishes
Bernard






"paula" wrote in message
...
i keep track of volunteer hours. each month i must post hours and need to
have them accumulate..in other workds..if they volunteered 3 hours in
october
and 3 in november, in need the total to automatically read 6 hours
total...how do i get started? what chart do i use?