View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Caroline Caroline is offline
external usenet poster
 
Posts: 183
Default Which function/formula?

I have a spreadhseet in which the 1st tab is the daily break down of reviews:
it has the employees' names and their numbers for every day of the month.
I want to add those up in a 2nd tab, and match the sum numbers to each
employees.
Here is what it looks like:

Tab1:

July 1st Reviewer A: 13
July 1st Reviewer B: 15
July 1st Reviewer C: 6

July 2nd Reviewer A: 9
July 2nd Reviewer B: 12
July 2nd Reviewer C: 4

etc...

I want this on tab 2:

July Reviewer A: sum for reviewer A for the whole month (sum from tab 1).
July Reviewer B: sum for reviewer B for the whole month
July Reviewer C: sum for reviewer C for the whole month

Thank you,
Caroline