formula help

  • Thread starter Thread starter The Celtic Warrior
  • Start date Start date
T

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/
 
=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)
 
IN accordance with the conditions stated, would not R1 always equal X1,
unless there were no matches?............

Vaya con Dios,
Chuck, CABGx3
 
Back
Top