Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Question... | Excel Discussion (Misc queries) | |||
sumproduct question | Excel Worksheet Functions | |||
SumProduct Question | Excel Worksheet Functions | |||
Question about sumproduct | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) |