# Sum if?? on calculation

This is a discussion on Sum if?? on calculation within the Excel Questions forums, part of the Question Forums category; Can anyone help me please. I have a table on one sheet with the following information: Process Activity Unit Time ...

1. ## Sum if?? on calculation

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

#### Posting Permissions

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