Sum if?? on calculation

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Sum if?? on calculation

  1. #1
    New Member
    Join Date
    Nov 2006
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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,478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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

User Tag List

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