Results 1 to 3 of 3

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. #1
    New Member
    Join Date
    Nov 2006
    Posts
    2

    Default 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. #2
    Board Regular Mike Blackman's Avatar
    Join Date
    Jun 2007
    Location
    Basingstoke, UK
    Posts
    2,445

    Default Re: Sum if?? on calculation

    Hi Rachel and welcome to the board,

    How about;

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

    Mikey B

  3. #3
    New Member
    Join Date
    Nov 2006
    Posts
    2

    Default 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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com