| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average IF 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% Is it possible for a formula to look at the BOXID and the 2nd and 3rd characters of the first row above and average the values. The result table would look like this (formula would be in B2:D3): 01 02 06 BOX005 15.25% 0.00% 0.00% BOX017 15.25% 0.00% 21.52% Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Formula | Excel Discussion (Misc queries) | |||
| in a pivot table, can the average include blank entries? | Excel Discussion (Misc queries) | |||
| Formula for determing average based on weighting | Excel Worksheet Functions | |||
| Average If Question | Excel Discussion (Misc queries) | |||
| Average If Question | Excel Discussion (Misc queries) | |||
Threaded Mode
