Sumproduct question
 

I have a 200 x 100 matrix.
Down the side in column A I have clients and they are Tier 1, 2 or 3.
Across the top in row 1 I have products, and they are rated A, B, or C.

Then in the 20000 squares there is a value (corresponding to their sales
with us)

How can I get the sum of all "A1s". ie, for all clients that are Tier1, what
are their sales in the "A" products?

Thanks in advance
Daniel

Daniel, try this:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Daniel Bonallack" wrote in
message ...
I have a 200 x 100 matrix.
Down the side in column A I have clients and they are Tier 1, 2 or 3.
Across the top in row 1 I have products, and they are rated A, B, or C.

Then in the 20000 squares there is a value (corresponding to their sales
with us)

How can I get the sum of all "A1s". ie, for all clients that are Tier1,
what
are their sales in the "A" products?

Thanks in advance
Daniel

Hi Anne

Thanks for replying - I'm familiar with the sumproduct formula, just not
with this specific application (the data is not laid out in such a way to
make a straight sumproduct formula possible).

Daniel


"Anne Troy" wrote:

Daniel, try this:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Daniel Bonallack" wrote in
message ...
I have a 200 x 100 matrix.
Down the side in column A I have clients and they are Tier 1, 2 or 3.
Across the top in row 1 I have products, and they are rated A, B, or C.

Then in the 20000 squares there is a value (corresponding to their sales
with us)

How can I get the sum of all "A1s". ie, for all clients that are Tier1,
what
are their sales in the "A" products?

Thanks in advance
Daniel

Would you post a 5-row sample?

Daniel Bonallack wrote:
I have a 200 x 100 matrix.
Down the side in column A I have clients and they are Tier 1, 2 or 3.
Across the top in row 1 I have products, and they are rated A, B, or C.

Then in the 20000 squares there is a value (corresponding to their sales
with us)

How can I get the sum of all "A1s". ie, for all clients that are Tier1, what
are their sales in the "A" products?

Thanks in advance
Daniel