| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Averaging Columns based on a Text String
Hello: I am attempting to average columns that have headings of Inventory. My spreadsheet consists of the following column headings: Inventory, Sales, Purchases. Each week I run a query that posts Inventory, Sales and Purchases for 450 Inventory items.How can I average the column heading of Inventory for the 52 weeks across these column headings. I tried using average(if(a1:a52 ="Inventory", a2:a52) but it doesn't work. Any help would be appreciated.
Thank you Gene Haines |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help setting the worksheet header/Footer margins based on string height? | Excel Discussion (Misc queries) | |||
| Create formula that will pull a value based on text in diff cell? | Excel Discussion (Misc queries) | |||
| Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
| VLOOKUP based on PART of another cell's text | Excel Discussion (Misc queries) | |||
| Turn Off Text To Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
