Finding all like data

  • Thread starter Thread starter The Lynns
  • Start date Start date
T

The Lynns

I am new at Excel and I need to make a volunteer sheet that will have two
columns. In the first column (A) I will have names. In the second column (B)
I will have the number of hours they work on a given day. What I need to
know is a formula that will find all like names in column (A) and total the
hours that they have worked in column (B). For example Bill may have worked
every other day for an entire month working a different amount of hours each
time. I need to know if there is a formula that would look all through
column (A) and everytime it finds the name Bill, it would add the associated
hours from column (B). I hope I have explained this well enough. Any help
will be appreciated.
 
Hi

there are a number of options you could use:

1) sumif function
=SUMIF(A:A,"Bill",B:B)
you could put the name Bill in D1 and the formula would then read
=SUMIF(A:A,D1,B:B)

2) sort & subtotal
Click in A2, choose Data / Sort
sort by Name
then choose
Data / Subtotal
at each change in Name
SUM
Hours

3) or you could use a pivot table
click in A2
Data / Pivot Table and Pivot Chart Report
Next
Finish
Drag Names to Place Row Headings Here (or similar wording)
Drag Hours to Place Data items here (or similar wording)


Hope this helps
Cheers
JulieD
 
If you have headed your columns A & B with "Volunteer"
& "Hours worked" respectivily
Select cell named "Volunteer"
Select "Data" on your toolbar menu
Select "Auto Filter" & click the adjacent box
Filterboxs will appear at the top of each column.
Use these filters to group data relating to each Volunteer
IMPORTANT return filter value to "All" before entering
new data!
 
Back
Top