Which function/formula?

C

Caroline

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
 
B

Bernard Liengme

We need to know more about how the data is actually set out on Sheet 1
Do you have the date in one cell, reviewer name in another and the number in
a third?
Is the first recode in A2:C2 or where?

On the other hand do you have a single cell with this text "July 1st
Reviewer A: 13"
If so it is going to be easier if you use Data | Text to Columns to get the
data into 3 (or more) columns

Please answer these points so we can better help
best wishes
 
C

Caroline

Yes, all are separated in different cells: A1 (date) A2 (reviewer name) A3
(number).
Thank you,
 
B

Bernard Liengme

On Sheet1 beginning in A1 I have
Date Reviewer Number
01/07/2009 a 1
01/07/2009 b 2
01/07/2009 c 3

02/07/2009 a 4
03/07/2009 b 5
04/07/2009 c 6

On Sheet2 I have
Reviewer Total
a 5
b 7
c 9

The formula in B2 is =SUMIF(Sheet1!$B$2:$B$8,A2,Sheet1!$C$2:$C$8)

Now this does not allow for the month - I am assuming all the data is for
July
If not then
=SUMPRODUCT(--(MONTH(Sheet1!$A$2:$A$8)=7),--(Sheet1!$B$2:$B$8=A2),Sheet1!$C$2:$C$8)


If you have Excel 2007, we could use SUMIFS for the second case
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top