Results 1 to 2 of 2

Thread: Multiply IF

  1. #1

    Multiply IF



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi everybody,
    I need to compare two rows of text and multiply the values if the text matches. It would be something like SUMIF, but with multiply instead of sum. For example:

    mouse- 1 monitor- 30 mouse- 10*1
    keyboard- 2 mouse- 10 keyboard- 15*2
    monitor- 1 keyboard- 15 monitor- 30*1

    I want it to work like SUMIF, compare the first two ranges and multiply the corresponding values.
    Thank you very much for your help!


  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Are you going to sum the products?

    I am not sure I am following? How do you get the 10*1, 15*2, 30*1? What is the final result you want? is it by row, or a totalling from all rows?


Posting Permissions

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