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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)
 
Back
Top