| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Obtaining an average by typing the salesman you want to see and the column to AVG
You could try using INDIRECT - along the lines of:
=AVERAGE(IF($C$2:$C$80=A84,INDIRECT("$"&A83&"$2:$" &A83&"$80"))) where A83 contains a single letter for the column to be averaged (e.g."Q") and A84 contains the name. Hope this helps. Pete |
Threaded Mode
