Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Apr 2005
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sumproduct (Excel 2000)

    Hi,

    Is there any way by which I can do a sumproduct formula based on a "if" condition. What I am looking for is something similar to sumif except that it should be sumproduct function.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: sumproduct (Excel 2000)

    Can you tell us a little more info to get us started? Is there anyway you can provide us with a cut down version of the wb please and attach it to your next post. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Jerry

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sumproduct (Excel 2000)

    You mean like this:

    <code>
    =SUMPRODUCT((A1:A9=1)*1,B1:B9,C1:C9)
    </code>

    That formula will sum the product of B1:B9 and C1:C9 if the corresponding cell in column A is equal to 1.
    Legare Coleman

  4. #4
    Lounger
    Join Date
    Apr 2005
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sumproduct (Excel 2000)

    Hi

    Reply given by Legare Coleman is exactly what I am looking for:
    =SUMPRODUCT((A1:A9=1)*1,B1:B9,C1:C9) -- That formula will sum the product of B1:B9 and C1:C9 if the
    corresponding cell in column A is equal to 1.
    Pls. let me know.
    Regards
    Ritesh

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: sumproduct (Excel 2000)

    I am little confused by your response.

    You seem to be responding to Jezza question about you are looking for, by saying the Legare's post is exactly what you are looking for, but there seems to be more of a question/desire than that and I don't understand it.

    If Legare's example is, however, "exactly" what you are looking for, I don't understand the implied question or desire for additional input.

    My impression is (and I apologize if I am wrong), that Legare's example is exactly the (type) of thing you are looking for, but you need something more specific. If this is true, then we need more details about what you need.

    Perhaps I am just reading too much into it...

    Steve

Posting Permissions

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