Finding an average with the lookup function

[td678]

Hello, I am new to the forums and certainly not an expert at Excel. Wha
I want to do is shown below:

=AVERAGE(LOOKUP(F56,F19:F55,C19:C55):C56)

Note that this function does not actually work. What I want to do is t
take a value (F56), go and find where it is previously in the F column
return the result from the corresponding C column, and then averag
everything between that corresponding C column result and C56. Thi
function does a good job at looking up the correct value, but I a
unable to figure out how to do the averaging part. Any help would b
greatly appreciated, as I have been stuck on this for hours. Thank you

 

[Claus Busch]

Hi,

Am Fri, 27 Jan 2012 16:14:04 +0000 schrieb td678:

Note that this function does not actually work. What I want to do is to
take a value (F56), go and find where it is previously in the F column,
return the result from the corresponding C column, and then average
everything between that corresponding C column result and C56. This
function does a good job at looking up the correct value, but I am
unable to figure out how to do the averaging part. Any help would be
greatly appreciated, as I have been stuck on this for hours. Thank you!

try:
=SUMIF(F19:F55,F56,C19:C55)/COUNTIF(F19:F55,F56)


Regards
Claus Busch

 

[Claus Busch]

Hi,

Am Fri, 27 Jan 2012 20:54:49 +0100 schrieb Claus Busch:

=SUMIF(F19:F55,F56,C19:C55)/COUNTIF(F19:F55,F56)

if you use xl2007 or higher, you can also try:
=AVERAGEIF(F19:F55,F56,C19:C55)


Regards
Claus Busch