# {Sum(if(...))*Sum(if(...))} Macro Help

#### DBWright

##### New Member
Currently I have 3 sheets:
Sheet 1:
........Jan Feb Mar
CustC 21 33 0
CustB 1 4 7

Sheet 2:
........Jan Feb Mar
CustB 6 7 0
CustC 9 6 8

Sheet 3:
........Jan Feb Mar
CustB
CustC

For Sheet 3, I need it to find CustB for the corresponding months in Sheets 1 and 2 and find the product. My current formula for CustB for Jan is:

{Sum(if(B2&A2=Sheet1!B2:C2&Sheet1!A1:A3,B2:C3))*Sum(if(B2&A2=Sheet2!B2:C2&Sheet2!A1:A3,B2:C3))}

The problem is, my dates go from Jan-11 to Dec-16 and I have 260 customers. I don't need to find just CustB, the formulas are populated for every customer on sheet 3. Therefore, when I populate formulas in all cells in sheet 3, it takes forever to run. When I change something in Sheets 1 or 2, it re-calculates and takes forever as well.

Is there a way to macro such a function?

Last edited:

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### psrs0810

##### Well-known Member
try recording the macro first. Then post it and someone may be able to help you with the specifics

Replies
8
Views
206
Replies
2
Views
91
Replies
1
Views
114
Replies
28
Views
234
Replies
4
Views
81

1,191,687
Messages
5,988,024
Members
440,125
Latest member
vincentchu2369

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