Sum if?? on calculation

Thanks:  0
Likes:  0

# Thread: Sum if?? on calculation

1. ## Sum if?? on calculation

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

2. ## Re: Sum if?? on calculation

Hi Rachel and welcome to the board,

=SUMPRODUCT(--(A1:A100="New Entrant"),((C1:C100)*(D1:D100)))

3. ## Re: Sum if?? on calculation

Thanks Mikey, that works perfectly, should have asked the question at 10am this morning rather than trying to solve it myself all day.

Cheers

Chubby

## 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
•