Assuming that A2:A4 contains the salesman name, and B1:D1 contains the
suburb, try...

B2, copied across and down:

=SUMPRODUCT(--(INDEX(Sales,0,1)=$A2),--(INDEX(Sales,0,2)=B$1),INDEX(Sales
,0,3))

Hope this helps!

http://www.xl-central.com

In article ,
Tabadi wrote:

I have a table with the following headings:

Salesman Suburb Amount

There are ~3,000 entries with multiples for each salesman & each suburb.
The whole array is named "sales".

I want to create a summary table on another worksheet that will give the sum
of all sales for each salesman and each suburb:

Salesman Suburb 1 Suburb 2 Suburb 3 ...... etc
Salesman 1
Salesman 2
Salesman 3
|
etc

I need a formula that will sum the values in "sales" that meets the criteria
of Salesman name and suburb.