ExcelBanter - View Single Post

Gene Haines

Quote:

Originally Posted by Bob Phillips

Shouldn't you use

=AVERAGE(if(a1:a52 ="Inventory", B2:B52))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gene Haines" wrote in message
...

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

--
Gene Haines

Bob: I am new to posting so I should have made myself a little more clear. For each week of the year I have 3 column headings,156 columns in total. As an example.
Item Inventory, 1st Week Jan Sales, 1st week Jan Purchase, Inventory, etc, etc. 52wkavg
ABC 365 456 192 356 432 176
DEF 213 125 234 256 139 142

It is in the 52wkavg column that I am trying to average across the columns only those that have the Inventory heading. I used your setup and it worked for which I thank you very much. I was not all that familiar with arrays and how to execute them.

Regards

Gene