formula help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Celtic Warrior - 15 Jul 2006 21:53 GMT

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

Signature

Rikk Flohr

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

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

Reply to this Message

Bob Phillips - 15 Jul 2006 23:46 GMT

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

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

Signature

HTH

Bob Phillips

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

> Is this possible?
>
[quoted text clipped - 8 lines]
>
> Where X1 is the pulldown value selected. R1 is the result

Reply to this Message

CLR - 16 Jul 2006 00:20 GMT

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

Vaya con Dios,
Chuck, CABGx3

> Is this possible?
>
[quoted text clipped - 16 lines]
>
> blog: http://spaces.msn.com/members/fleetingglimpse/

Reply to this Message

Rate this thread: