---
title: "CORREL function in Excel: syntax and examples | ExcelSavvy"
description: "How to use CORREL in Excel and Google Sheets: measure how closely two columns of numbers move together."
canonical_url: "https://excelsavvy.com/functions/correl"
meta:
  "og:description": "How to use CORREL in Excel and Google Sheets: measure how closely two columns of numbers move together."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Q09SUkVMIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBDT1JSRUwgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IG1lYXN1cmUgaG93IGNsb3NlbHkgdHdvIGNvbHVtbnMgb2YgbnVtYmVycyBtb3ZlIHRvZ2V0aGVyLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09SUkVMKGFycmF5MSwgYXJyYXkyKQ%2Cp_Ii9mdW5jdGlvbnMvY29ycmVsIg%2Cs_1jaG9tZqZ0a9A5TD.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "CORREL function in Excel: syntax and examples | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Q09SUkVMIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBDT1JSRUwgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IG1lYXN1cmUgaG93IGNsb3NlbHkgdHdvIGNvbHVtbnMgb2YgbnVtYmVycyBtb3ZlIHRvZ2V0aGVyLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09SUkVMKGFycmF5MSwgYXJyYXkyKQ%2Cp_Ii9mdW5jdGlvbnMvY29ycmVsIg%2Cs_1jaG9tZqZ0a9A5TD.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **The CORREL function**

Returns the correlation coefficient of two ranges, from -1 to 1. Close to 1 means the two rise together, close to -1 that one falls as the other rises, and close to 0 no straight-line link.

=

CORREL(

## **How to use CORREL**

CORREL tells you whether two columns of numbers move together, and how tightly. Think of ice cream sales and temperature: on hot days both go up. CORREL turns that feeling into a single number between -1 and 1.

Use it on pairs of numbers where row 2 in one column belongs with row 2 in the other: ad spend and sales per month, temperature and sales per day, hours of training and test score per employee. With `**=CORREL(A2:A6,B2:B6)**`, a result near 1 means the two rise together, near -1 means one falls as the other rises, and near 0 means there is no straight-line link. The ranges must be the same size, and the order does not matter: swap them and you get the same number.

CORREL only finds straight lines. A curve or a single odd value can give a result near 0 even when the link is clear, so draw a scatter chart before you trust the number. A high result also says nothing about cause. To describe one column on its own, use AVERAGE or MEDIAN.

## **Syntax**

```
CORREL(array1, array2)
```

<dl><dt>**array1 **</dt>
<dd>The first range of numbers.</dd>
<dt>**array2 **</dt>
<dd>The second range, the same size as the first.</dd></dl>

## **Examples**

D1`=CORREL(<sup>1</sup>A2:A6,<sup>2</sup>B2:B6)`

|  | A | B | C | D |
| --- | --- | --- | --- | --- |
| 1 | Ad spend | Sales |  | **0.98644** |
| 2 | 10 | 120 |  | |
| 3 | 20 | 150 |  | |
| 4 | 30 | 200 |  | |
| 5 | 40 | 210 |  | |
| 6 | 50 | 260 |  | |

**In plain words:** How closely <sup>1</sup>the ad spend in A2:A6 and <sup>2</sup>the sales in B2:B6 move together.

## **Common CORREL mistakes**

- CORREL returns #N/A

  The two ranges have different sizes. Use the same number of cells in both, like `**=CORREL(A2:A13,B2:B13)**`.
- CORREL returns #DIV/0!

  One of the ranges is empty, has no numbers, or has the same value in every cell. CORREL needs numbers that vary in both columns.
- The result is near 0 but the data clearly belong together

  CORREL measures straight-line links only. If the numbers follow a curve, or one extreme value pulls the result, plot the two columns in a scatter chart to see the real pattern.
- The result ignores some of my numbers

  Numbers stored as text are skipped. They usually sit on the left side of the cell. Convert them to real numbers, for example with VALUE in a helper column, and run CORREL again.

## **Questions**

<details>

<summary>

### Does a high correlation mean one thing causes the other?

</summary>

No. CORREL only measures how closely two columns move together in a straight line. Both may be driven by something else, like the season.

</details>

<details>

<summary>

### What counts as a strong correlation?

</summary>

A result above 0.7 or below -0.7 is often called strong, but it depends on your field and on how many data points you have. A few rows can give a high result by chance.

</details>

<details>

<summary>

### What is the difference between CORREL and PEARSON?

</summary>

None. Both return the same correlation coefficient, so you can use either.

</details>

## **Related functions**

- [**AVERAGE**](https://excelsavvy.com/functions/average)
- [**MEDIAN**](https://excelsavvy.com/functions/median)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/functions/correl#webpage","dateModified":"2026-11-16","description":"How to use CORREL in Excel and Google Sheets: measure how closely two columns of numbers move together.","name":"CORREL function in Excel: syntax and examples","url":"https://excelsavvy.com/functions/correl","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/functions/correl#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/functions/correl#/schema/question/1"},{"@id":"https://excelsavvy.com/functions/correl#/schema/question/2"},{"@id":"https://excelsavvy.com/functions/correl#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/functions/correl"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/functions/correl#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel functions","item":"https://excelsavvy.com/functions","position":2},{"@type":"ListItem","name":"CORREL function in Excel: syntax and examples","position":3}]},{"@id":"https://excelsavvy.com/functions/correl#article","dateModified":"2026-11-16","description":"How to use CORREL in Excel and Google Sheets: measure how closely two columns of numbers move together.","headline":"CORREL function in Excel: syntax and examples","inLanguage":"en-US","thumbnailUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Q09SUkVMIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBDT1JSRUwgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IG1lYXN1cmUgaG93IGNsb3NlbHkgdHdvIGNvbHVtbnMgb2YgbnVtYmVycyBtb3ZlIHRvZ2V0aGVyLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09SUkVMKGFycmF5MSwgYXJyYXkyKQ%2Cp_Ii9mdW5jdGlvbnMvY29ycmVsIg%2Cs_1jaG9tZqZ0a9A5TD.png","@type":["Article","TechArticle"],"author":{"@id":"https://excelsavvy.com/#identity"},"image":{"@id":"https://excelsavvy.com/#/schema/image/1"},"isPartOf":{"@id":"https://excelsavvy.com/functions/correl#webpage"},"mainEntityOfPage":{"@id":"https://excelsavvy.com/functions/correl#webpage"},"publisher":{"@id":"https://excelsavvy.com/#identity"}},{"@id":"https://excelsavvy.com/functions/correl#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Does a high correlation mean one thing causes the other?","acceptedAnswer":{"@type":"Answer","text":"No. CORREL only measures how closely two columns move together in a straight line. Both may be driven by something else, like the season."}},{"@id":"https://excelsavvy.com/functions/correl#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"What counts as a strong correlation?","acceptedAnswer":{"@type":"Answer","text":"A result above 0.7 or below -0.7 is often called strong, but it depends on your field and on how many data points you have. A few rows can give a high result by chance."}},{"@id":"https://excelsavvy.com/functions/correl#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"What is the difference between CORREL and PEARSON?","acceptedAnswer":{"@type":"Answer","text":"None. Both return the same correlation coefficient, so you can use either."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"},{"@id":"https://excelsavvy.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Q09SUkVMIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBDT1JSRUwgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IG1lYXN1cmUgaG93IGNsb3NlbHkgdHdvIGNvbHVtbnMgb2YgbnVtYmVycyBtb3ZlIHRvZ2V0aGVyLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09SUkVMKGFycmF5MSwgYXJyYXkyKQ%2Cp_Ii9mdW5jdGlvbnMvY29ycmVsIg%2Cs_1jaG9tZqZ0a9A5TD.png","inLanguage":"en-US","url":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Q09SUkVMIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBDT1JSRUwgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IG1lYXN1cmUgaG93IGNsb3NlbHkgdHdvIGNvbHVtbnMgb2YgbnVtYmVycyBtb3ZlIHRvZ2V0aGVyLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09SUkVMKGFycmF5MSwgYXJyYXkyKQ%2Cp_Ii9mdW5jdGlvbnMvY29ycmVsIg%2Cs_1jaG9tZqZ0a9A5TD.png"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
