Averaging in arrays

T

Tom

Hi,

I thought I saw the answer to this before, but I can't seemt to find it

Here's the scenario

Column A has lists of Cities (ie: Boston, Chicago etc..)
Column B has List of inventory
Column C has amout of time in hours:Min:sec sitting in inventory

Column lengths could be in hundreds

I want to do formula that Produce results for example

Boston Blue widgets 236:45:00

All help appreciated
 
J

Jason morin

Without testing...

=AVERAGE(IF((A1:A1000="Boston")*(B1:B1000="Blue
Widget"),C1:C1000))

Array-entered, meaning press ctrl/shift/enter.

HTH
Jason
Atlanta, GA
 
A

Alan Beban

Tom said:
Hi,

I thought I saw the answer to this before, but I can't seemt to find it

Here's the scenario

Column A has lists of Cities (ie: Boston, Chicago etc..)
Column B has List of inventory
Column C has amout of time in hours:Min:sec sitting in inventory

Column lengths could be in hundreds

I want to do formula that Produce results for example

Boston Blue widgets 236:45:00

All help appreciated
Click to expand...
What is it that is proposed to be averaged?

Alan Beban
 
T

Tom

I want to avearge the amount of time that an Item sit's in inventory
for a particular item or city. In some cases to do comparisons.

By the way, I did use a pivot table, and then tried to find the same
answer using formulas, and got different answers, that is why I
posted, cause I wasn't sure I was doing it correctly
 
A

Alan Beban

Perhaps I'm being inordinately thick, but it looks like in, e.g., A1 is
a city, B1 is an inventory item, and C1 is a time in inventory for that
item in that city. Where are the other times to be averaged with C1???

Alan Beban
 
Top