# Product if formula

1. ## Product if formula

Hi Everyone!

Good Day!

My name is Amy and I'm here because I need your help.

I wanted to compute for the cost of rejects (column J) with the following criteria:
1. If column G match with column B.
2. If column I match with column C.
3. Then column H should be multiplied to column D that meets the previous criteria.

I hope anybody from here could help. Please. Thank you!

2. ## Re: Product if formula

You can use:

=H2*SUMIFS(D:D,B:B,G2,C:C,I2)

copied down.

3. ## Re: Product if formula

In J2 try
Formula:
`Please Login or Register  to view this content.`

Committed as an array formula with Ctrl+Shift+Enter

4. ## Re: Product if formula

Wow! Sir Glenn Kennedy! Thank you so much!!! . This is amazing! It really works.
You have no idea that I've been working for this for almost 2 weeks and have tried many formula but didn't work.

You are an excel HERO! You are amazing! Thank you!

5. ## Re: Product if formula

Hi Pepe!

Thank you everyone!

You are all now my excel friends!!!

6. ## Re: Product if formula

You're welcome.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1