View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default How Do I? Perform simple Average on a indexed text location

Here's another view & venture on your original post ...

Source data is assumed running in Sheet2's A2:B2 down,
eg:

Tigers 4
Lions 2
Bears 3
Lions 7
Bears 5
Tigers 9
etc

In Sheet1,
With the unique "animals", eg: Tigers, etc listed in A2 down
Paste this into B2, then press CTRL+SHIFT+ENTER to confirm the formula:
=AVERAGE(IF(Sheet2!A$2:A$100=A2,Sheet2!B$2:B$100))
Copy B2 down. Adapt the ranges to suit the actual extents of your data.

Success? High-five it, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---