Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumProduct Question
My data table looks like this:
BOXID 60103 60101 60622 60626 BOX005 0.00% 30.51% 0.00% 0.00% BOX009 0.05% 0.53% 0.01% 0.00% BOX017 16.31% 14.20% 19.71% 23.34% BOX050 0.19% 0.02% 1.92% 0.88% BOX060 0.00% 0.00% 0.00% 0.00% BOX074 0.00% 0.00% 0.00% 0.00% I am trying to find a formula that will give the average of the data relating to the BOXID and the 2nd and 3rd characters of row 1 of the data table. The result would be like this for example. 1 2 6 BOX005 15.25% 0.00% 0.00% BOX017 15.25% 0.00% 21.52% Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumProduct Question
See your later post.
Biff "carl" wrote in message ... My data table looks like this: BOXID 60103 60101 60622 60626 BOX005 0.00% 30.51% 0.00% 0.00% BOX009 0.05% 0.53% 0.01% 0.00% BOX017 16.31% 14.20% 19.71% 23.34% BOX050 0.19% 0.02% 1.92% 0.88% BOX060 0.00% 0.00% 0.00% 0.00% BOX074 0.00% 0.00% 0.00% 0.00% I am trying to find a formula that will give the average of the data relating to the BOXID and the 2nd and 3rd characters of row 1 of the data table. The result would be like this for example. 1 2 6 BOX005 15.25% 0.00% 0.00% BOX017 15.25% 0.00% 21.52% Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct Question | Excel Discussion (Misc queries) | |||
Sumproduct Question | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) | |||
sumproduct question | Excel Worksheet Functions |