Combine adding numbers and color formatting

[Memar]

[h=2]I just want to add a total amount for region East, Branch 1 and product 1 only for the months highlighted in blues. The result is shown in a different workbook (A), but the data/ information is saved in a different workbook (B). I want the result to be shown in workbook A whether workbook B is open or closed.

Month	Region	Location	Amount	Product
July-18	East	Branch 1	700.02	Product 1
July-18	WEST	Branch 2	1,596.90	Product 2
July-18	WEST	Branch 3	2,160.30	Product 3
July-18	NORTH	Branch 4	223.08	Product 4
July-18	East	Branch 5	842.70	Product 5
August-18	SOUTH	Branch 1	4,330.61	Product 1
August-18	NORTH	Branch 2	741.78	Product 2
August-18	WEST	Branch 3	64.45	Product 3
August-18	WEST	Branch 4	2,139.30	Product 4
August-18	SOUTH	Branch 5	1,131.04	Product 5
August-18	East	Branch 1	293.85	Product 1
August-18	NORTH	Branch 2	1,469.25	Product 2
August-18	WEST	Branch 3	1,312.52	Product 3
August-18	WEST	Branch 4	5,133.76	Product 4
August-18	SOUTH	Branch 5	984.39	Product 5
September-18	East	Branch 1	1,643.71	Product 1
September-18	NORTH	Branch 2	795.90	Product 2
September-18	SOUTH	Branch 3	1,349.63	Product 3
September-18	SOUTH	Branch 4	1,282.70	Product 4
September-18	NORTH	Branch 5	32.23	Product 5
September-18	SOUTH	Branch 1	145.00	Product 1
September-18	SOUTH	Branch 2	1,833.77	Product 2
September-18	East	Branch 3	721.89	Product 3
September-18	SOUTH	Branch 4	227.40	Product 4
September-18	NORTH	Branch 5	1,399.48	Product 5
September-18	East	Branch 1	1,421.90	Product 1
September-18	SOUTH	Branch 2	1,904.85	Product 2
September-18	WEST	Branch 3	3,835.31	Product 3
September-18	WEST	Branch 4	2,207.06	Product 4
September-18	SOUTH	Branch 5	175.01	Product 5

<tbody>
</tbody>

The desired result in this example is $3,065.00

Thank you for your help and time.[/h]

 

[oldbrewer]

Month

Region

Location

Amount

Product

1-Jul-18

East

Branch 1

700.02

Product 1

1-Jul-18

WEST

Branch 2

1,596.90

Product 2

1-Jul-18

WEST

Branch 3

2,160.30

Product 3

date

1-Sep-18

1-Jul-18

NORTH

Branch 4

223.08

Product 4

location

Branch 1

1-Jul-18

East

Branch 5

842.7

Product 5

product

Product 1

1-Aug-18

SOUTH

Branch 1

4,330.61

Product 1

region

East

1-Aug-18

NORTH

Branch 2

741.78

Product 2

1-Aug-18

WEST

Branch 3

64.45

Product 3

1-Aug-18

WEST

Branch 4

2,139.30

Product 4

3065.61

1-Aug-18

SOUTH

Branch 5

1,131.04

Product 5

1-Aug-18

East

Branch 1

293.85

Product 1

1-Aug-18

NORTH

Branch 2

1,469.25

Product 2

=SUMPRODUCT(($A$2:$A$31=$K$4)*($B$2:$B$31=$K$7)*($C$2:$C$31=$K$5)*($E$2:$E$31=$K$6)*($D$2:$D$31))

1-Aug-18

WEST

Branch 3

1,312.52

Product 3

1-Aug-18

WEST

Branch 4

5,133.76

Product 4

1-Aug-18

SOUTH

Branch 5

984.39

Product 5

1-Sep-18

East

Branch 1

1,643.71

Product 1

1-Sep-18

NORTH

Branch 2

795.9

Product 2

1-Sep-18

SOUTH

Branch 3

1,349.63

Product 3

1-Sep-18

SOUTH

Branch 4

1,282.70

Product 4

if you change any or all of the 4 variables you will get the desired total

1-Sep-18

NORTH

Branch 5

32.23

Product 5

1-Sep-18

SOUTH

Branch 1

145

Product 1

1-Sep-18

SOUTH

Branch 2

1,833.77

Product 2

1-Sep-18

East

Branch 3

721.89

Product 3

1-Sep-18

SOUTH

Branch 4

227.4

Product 4

1-Sep-18

NORTH

Branch 5

1,399.48

Product 5

1-Sep-18

East

Branch 1

1,421.90

Product 1

1-Sep-18

SOUTH

Branch 2

1,904.85

Product 2

1-Sep-18

WEST

Branch 3

3,835.31

Product 3

1-Sep-18

WEST

Branch 4

2,207.06

Product 4

1-Sep-18

SOUTH

Branch 5

175.01

Product 5

<colgroup><col width="64" span="19" style="width:48pt"> </colgroup><tbody>
</tbody>