# Correlating two range, need to adjust one range first

1. ## Correlating two range, need to adjust one range first

I need to correlate Column A with Column C, but first I'd like to adjust the numbers Column A with a COUNTIF on Column B. So if Column B is >5 I'm adjusting Column A up a point.

This is large sheet so I'm unable to just make helper columns for everything. Here's my blunt attempt but it does not adjust Column A. Any solutions?

=ArrayFormula(CORREL(A2:A+COUNTIF(B2:B,">5"),C2:C))

3. ## Re: Correlating two range, need to adjust one range first

Added a very basic sheet. I hope it's clear what I'm asking.

4. ## Re: Correlating two range, need to adjust one range first

``Please Login or Register  to view this content.``
which you may need to commit to the sheet with Ctrl+Shift+Enter rather than plain Enter depending on your version of Excel.

In which case:
``Please Login or Register  to view this content.``

5. ## Re: Correlating two range, need to adjust one range first

That's it. You're the man.

There are currently 1 users browsing this thread. (0 members and 1 guests)