1. ## 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. ## 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>

3. ## 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.

4. ## 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. ## 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
•