rachelchubb
New Member
- Joined
- Nov 30, 2006
- Messages
- 2
Can anyone help me please.
I have a table on one sheet with the following information:
Process Activity Unit Time Volume
New Entrant New Entrants 10 246
New Entrant NE Queries 17 27
Increments Misc Inc Queries 17 5
Increments Increments 10 100
Transfer in Bulk SP/TV 60 50
On another sheet I need to basically calculate the total time for New entrants, Increments etc. I have a big list of these so I don't want just to manually put the formulas in. I was trying to do a sumif but what I need to do is multiply unit time by volume and sumif wasn't working for this.
Any suggestions?
chubby
I have a table on one sheet with the following information:
Process Activity Unit Time Volume
New Entrant New Entrants 10 246
New Entrant NE Queries 17 27
Increments Misc Inc Queries 17 5
Increments Increments 10 100
Transfer in Bulk SP/TV 60 50
On another sheet I need to basically calculate the total time for New entrants, Increments etc. I have a big list of these so I don't want just to manually put the formulas in. I was trying to do a sumif but what I need to do is multiply unit time by volume and sumif wasn't working for this.
Any suggestions?
chubby