formula help

[The Celtic Warrior]

Is this possible?

Find all cells in a column which match an item from a pull down list.
Perform a sum of those rows in a different column and divide by a count of
the matches to obtain an average.

for one cell it might be like this.

If X1 = C3 then R1=(Running SUM of C column matches)/ Count of C Column
matches

Where X1 is the pulldown value selected. R1 is the result

--
Rikk Flohr

gallery: www.fleetingglimpse.com
consulting: www.fleetingglimpse.net

blog: http://spaces.msn.com/members/fleetingglimpse/

 

[Bob Phillips]

=AVERAGE(IF(C1:C100=X1,C1:C1000))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[CLR]

IN accordance with the conditions stated, would not R1 always equal X1,
unless there were no matches?............

Vaya con Dios,
Chuck, CABGx3