# Help with formula

#### jasedc5r

##### New Member
Hi All,

I hope someone could help me with a formula which have spent a few hours trying to formulate, however, without any success (beginner level).

I have two worksheets (Sheet 1 and Sheet 2). Cell highlighted in yellow, I need to formulate the total quantity of parts required for the month based of the number of cars from the schedule plan (Sheet 2). The schedule plan is setup based on the job plans.

So the formula I need is - job plan from column B to I (sheet 1), lookup job plans in (sheet 2), find month, the value of number of cars and multiple by 'Qty per job' value (Sheet 1, column A) for each job plan entry from column B to I.

Sheet 1

Sheet 2

#### Attachments

• 1616551660316.png
13.1 KB · Views: 5

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### hajiali

##### Active Member
can you set an example for few of them?

#### Marcelo Branco

##### MrExcel MVP
Maybe...

Formula in Sheet1 J3 copied across and down
=SUMPRODUCT(SUMIFS(INDEX(Sheet2!\$B\$4:\$V\$7,0,MATCH(J\$2,Sheet2!\$B\$2:\$V\$2,0)),Sheet2!\$A\$4:\$A\$7,\$B3:\$I3))*\$A3

M.

#### jasedc5r

##### New Member
Works a treat. Thanks Marcelo

M.

Replies
0
Views
120
Replies
6
Views
144
Replies
3
Views
65
Replies
2
Views
139
Replies
0
Views
26

1,132,912
Messages
5,655,911
Members
418,250
Latest member
Jebacmakro

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back