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

DBWright

New Member
Joined
Mar 11, 2011
Messages
2
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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
try recording the macro first. Then post it and someone may be able to help you with the specifics
 
Upvote 0

Forum statistics

Threads
1,222,149
Messages
6,164,238
Members
451,882
Latest member
Bigtop

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top