In support of this Thread
https://excelfox.com/forum/showthrea...tiple-Criteria
and answer
https://excelfox.com/forum/showthrea...ll=1#post15046


After running Sub Arrays1()

_____ Workbook: AllFormulasAndVBAMultipleCriteria.xlsm ( Using Excel 2007 32 bit )
Row\Col A B C D E
1 Sales Man Territory Dimension Sales Amt Cost
2 John New York Tissue 1000 200
3 John New York Soda 2050 1500
4 John New York Paper
5 John New York Towel
6 John Washington Tissue
7 John Washington Soda
8 John Washington Paper
9 John Washington Towel
10 Alfred New York Tissue 2000 500
11 Alfred New York Soda
12 Alfred New York Paper
13 Alfred New York Towel
14 Alfred Washington Tissue
15 Alfred Washington Soda 2100 700
16 Alfred Washington Paper
17 Alfred Washington Towel
18 Leo New York Tissue 3500 1500
19 Leo New York Soda
20 Leo New York Paper
21 Leo New York Towel
22 Leo Washington Tissue
23 Leo Washington Soda 200 100
24 Leo Washington Paper
25 Leo Washington Towel
26 Maxwell New York Tissue
27 Maxwell New York Soda
28 Maxwell New York Paper
29 Maxwell New York Towel
30 Maxwell Washington Tissue
31 Maxwell Washington Soda
32 Maxwell Washington Paper
33 Maxwell Washington Towel 1000 800
Worksheet: ResultVBA