CORREL - IF Command .....

[john.shaddix]

I think this is a type of array formula but i am having trouble getting
it right...

simple problem...

col A has summer/winter

col B has a list of values
col C has a list of values

I want to get a correlation of the two lists (col B and col C) if
summer and if winter.

I DO REALIZE that i could just select the specific cells that
correspond to summer/winter....but i am obviously looking for an easier
way. Thanks.


john

 

[vandenberg p]

Hello:

Sort the columns (A,B,C) on column A. Then you can enter two correl
formula one for summer (it will be sorted first) and second for winter
it will be sort last.

Pieter Vandenberg

(e-mail address removed) wrote:
: I think this is a type of array formula but i am having trouble getting
: it right...

: simple problem...

: col A has summer/winter

: col B has a list of values
: col C has a list of values

: I want to get a correlation of the two lists (col B and col C) if
: summer and if winter.

: I DO REALIZE that i could just select the specific cells that
: correspond to summer/winter....but i am obviously looking for an easier
: way. Thanks.


: john