Thanks:  0
Likes:  0

1. Basicly the spread sheet is a log that we must complete daily. On the sheet we must enter the amount of minutes we work on each project in column C and the code that it falls under in row D (which can be found on the bottom of the page). Then total them all up by code for the day by minutes and enter them in the correct code total box at the bottom of the page. Is there any way to write a formula that will automatically total the minutes for any row that falls under the column C and has the designated code id # (1-7) in column D and place it in the correct totals box at the bottom of the page?

I have been sitting at my desk for 2 days.....Any info would be great...We are not responsible to put the start time and end time...

[ This Message was edited by: nickb on 2002-03-14 15:57 ]

2. On 2002-03-14 15:44, nickb wrote:
Basicly the spread sheet is a log that we must complete daily. On the sheet we must enter the amount of minutes we work on each project in column C and the code that it falls under in row D (which can be found on the bottom of the page). Then total them all up by code for the day by minutes and enter them in the correct code total box at the bottom of the page. Is there any way to write a formula that will automatically total the minutes for any row that falls under the column C and has the designated code id # (1-7) in column D and place it in the correct totals box at the bottom of the page?

I have been sitting at my desk for 2 days.....Any info would be great...I am including an attachment of the spreadsheet that has a day of minutes and what it must look like.
We are not responsible to put the start time and end time...

I don't see any attachment.

3. Sorry...I just copied that from a email to a friend ...can we attach excel files?

4. Nope (regarding attachments). Try a =sumif function. Go through the function wizard (click the old fx button). Criteria in D, values to sum in C.

Or do subtotals. Click Data->Subtotals... Sum by each change in code (d). Might need to sort your data first...

Hope this helps.

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-03-14 16:01 ]

5. On 2002-03-14 15:54, nickb wrote:
Sorry...I just copied that from a email to a friend ...can we attach excel files?
I believe it is as yet not possible.

You could perhaps give a sample of 5 entries from C along with the cell address where you want the total.

6. would this do what you want:
=SUMIF(B1:B11,1,A1:A11)/60
you'd have to put this formula in each of your code total boxes (i assume there are 7 of these, one for each code total). the formula above will work for code total box #1, but you'd have to change the '1' to a '2' for code total box 2 and so on. the /60 gives the number of hours, but as a fraction.
does that help?
oops. that first formula should be
=SUMIF(D1:D11,1,C1:C11)/60

[ This Message was edited by: anno on 2002-03-14 16:57 ]

7. If D is the criteria range and C is the data in minutes and you want totals in minutes

=SUMIF(d1:d30000,1,c1:c30000)
=SUMIF(d1:d30000,2,c1:c30000)
=SUMIF(d1:d30000,3,c1:c30000)

etc....Oughta win the battle.

Cheers, NateO

[ This Message was edited by: NateO on 2002-03-14 16:41 ]

[ This Message was edited by: 2077delta on 2002-03-14 17:26 ]

[ This Message was edited by: 2077delta on 2002-03-14 17:27 ]

9. NateO you are a GOD!!!!!

Bro you have no idea has satisfied I am. Thank you for taking the tim eto help with my problem....Board Master is an understatement..

thanks..

10. Nick, I like your attitude!

Glad to be of assistance, all's well that ends well.

Happy St. Patty's!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•