Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Cells to a grand total
I have three employees that can work between 3 and 5 days per week. The
data looks like this: Hours are recorded for the day and the weekly pay is calculated on the total line. Date Employee1 Employee2 Employee3 1/1/05 8 8 8 1/2/05 8 8 8 1/3/05 8 8 8 Total 600.00 500.00 450.00 1/8/05 8 8 8 1/9/05 8 8 8 Total 325.00 305.00 312.00 1/10/05 8 8 8 1/11/05 8 8 8 1/13/05 8 8 8 1/14/05 8 8 8 1/15/05 8 8 8 Total 600.00 500.00 450.00 Is there a way to total all the total dollars for each employee programatically? On the total lines for each employee is a =SUM formula to calculate the dollar amount. Since there are about a years worth of data this would help lots. Thanks, Gary |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Cells to a grand total
Gary
have a look at SUMIF =SUMIF(A2:Axxx,"Total",B2,Bxxx) Or if the totals are in a dufferent column, you could just use: =SUMIF(A:A,"Total",B,B) Regards Trevor "Gary Paris" wrote in message ... I have three employees that can work between 3 and 5 days per week. The data looks like this: Hours are recorded for the day and the weekly pay is calculated on the total line. Date Employee1 Employee2 Employee3 1/1/05 8 8 8 1/2/05 8 8 8 1/3/05 8 8 8 Total 600.00 500.00 450.00 1/8/05 8 8 8 1/9/05 8 8 8 Total 325.00 305.00 312.00 1/10/05 8 8 8 1/11/05 8 8 8 1/13/05 8 8 8 1/14/05 8 8 8 1/15/05 8 8 8 Total 600.00 500.00 450.00 Is there a way to total all the total dollars for each employee programatically? On the total lines for each employee is a =SUM formula to calculate the dollar amount. Since there are about a years worth of data this would help lots. Thanks, Gary |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Cells to a grand total - Thanks
Thanks... Worked like a charm!
"Trevor Shuttleworth" wrote in message ... Gary have a look at SUMIF =SUMIF(A2:Axxx,"Total",B2,Bxxx) Or if the totals are in a dufferent column, you could just use: =SUMIF(A:A,"Total",B,B) Regards Trevor "Gary Paris" wrote in message ... I have three employees that can work between 3 and 5 days per week. The data looks like this: Hours are recorded for the day and the weekly pay is calculated on the total line. Date Employee1 Employee2 Employee3 1/1/05 8 8 8 1/2/05 8 8 8 1/3/05 8 8 8 Total 600.00 500.00 450.00 1/8/05 8 8 8 1/9/05 8 8 8 Total 325.00 305.00 312.00 1/10/05 8 8 8 1/11/05 8 8 8 1/13/05 8 8 8 1/14/05 8 8 8 1/15/05 8 8 8 Total 600.00 500.00 450.00 Is there a way to total all the total dollars for each employee programatically? On the total lines for each employee is a =SUM formula to calculate the dollar amount. Since there are about a years worth of data this would help lots. Thanks, Gary |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Cells to a grand total - Thanks
You're welcome
"Gary Paris" wrote in message ... Thanks... Worked like a charm! "Trevor Shuttleworth" wrote in message ... Gary have a look at SUMIF =SUMIF(A2:Axxx,"Total",B2,Bxxx) Or if the totals are in a dufferent column, you could just use: =SUMIF(A:A,"Total",B,B) Regards Trevor "Gary Paris" wrote in message ... I have three employees that can work between 3 and 5 days per week. The data looks like this: Hours are recorded for the day and the weekly pay is calculated on the total line. Date Employee1 Employee2 Employee3 1/1/05 8 8 8 1/2/05 8 8 8 1/3/05 8 8 8 Total 600.00 500.00 450.00 1/8/05 8 8 8 1/9/05 8 8 8 Total 325.00 305.00 312.00 1/10/05 8 8 8 1/11/05 8 8 8 1/13/05 8 8 8 1/14/05 8 8 8 1/15/05 8 8 8 Total 600.00 500.00 450.00 Is there a way to total all the total dollars for each employee programatically? On the total lines for each employee is a =SUM formula to calculate the dollar amount. Since there are about a years worth of data this would help lots. Thanks, Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Grand Total - Cells Blank | Excel Discussion (Misc queries) | |||
Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
Grand total time between two total cells | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions |