Re: Obtaining an average by typing the salesman you want to see and the column to AVG

Giganews Newsgroups
Subject: Re: Obtaining an average by typing the salesman you want to see and the column to AVG
Posted by:  Pete_UK (pashur…@auditel.net)
Date: 25 May 2006

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

Replies

None

In response to

Obtaining an average by typing the salesman you want to see and the column to AVG posted by furryfishus on Thu, 25 May 2006