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

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

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

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