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

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Caroline" wrote in message
...
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