Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which function/formula?
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which function/formula?
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which function/formula?
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Caroline" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Function formula | Excel Worksheet Functions | |||
Help with OR function in IF function formula | Excel Worksheet Functions | |||
how do i add a function to a formula? | Excel Discussion (Misc queries) | |||
Help with formula/function | Excel Worksheet Functions | |||
A formula/function to return a formula/function | Excel Worksheet Functions |