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/
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/