How to Make a RACI Matrix in Excel With Built-In Checks

A RACI matrix in Excel is a grid that shows who does what on a project: tasks run down the rows, people run across the columns, and each cell holds R, A, C or I. Excel makes it more than a table, because a drop-down list keeps the letters clean, COUNTIF checks that every task has one owner, and colours make the pattern easy to read. This guide builds one step by step.

What is a RACI matrix?#

A RACI matrix, also called a responsibility assignment matrix, records each person's role on each task. The four letters are:

The two rules most teams follow are: every task has exactly one A, and every task has at least one R. Without an A, nobody owns the decision. With two, people wait for each other.

How to set up the RACI grid#

Start with a plain grid. Put tasks in column A and people or roles in row 1:

A few layout tips:

• Use roles (Project lead, Designer) instead of names if people change often.
• Keep tasks at a useful level. A row for "Launch" is enough; a row for every email is too much.
• Freeze the top row and first column with View > Freeze Panes so names and tasks stay visible as you scroll.

If the RACI sits next to a schedule, see how to build a project timeline in Excel. Both are core tools in the list of Excel skills for project managers.

How to add an R/A/C/I drop-down list#

A drop-down list stops typos like "a ", "Acc" or "R " that would break your checks. To add it:

1. Select the letter cells, B2:E7.
2. Go to Data > Data Validation (in the Data Tools group).
3. Under Allow, choose List.
4. In Source, type R,A,C,I and click OK.

Now each cell has an arrow with the four letters, and Excel rejects anything else. If you allow combined roles, add them to the list, such as R,A,C,I,A/R. The data validation drop-down guide covers lists that come from a range instead.

How to check each task with COUNTIF#

COUNTIF counts the cells in a range that match a condition, so it can count the letters in each row. In F2, type:

=IF(COUNTIF(B2:E2,"A")<>1,"Need one A",IF(COUNTIF(B2:E2,"R")=0,"Need an R","OK"))

Fill it down to F7 (Windows: Ctrl+D; Mac: ⌘D). The results are:

The first IF checks for exactly one A. Row 3 has two (Ana and Chloe). Only if that passes does the second IF check for at least one R. Row 7 has an A but nobody doing the work.

To count problem rows across the whole matrix, use =COUNTIF(F2:F7,"<>OK"), which returns 2. Put it at the top so you see it before sharing the file. The COUNTIF function guide and the article on how COUNTIF criteria work explain the "<>OK" style of criteria.

How to see each person's workload#

Count the letters down each person's column to see who carries the most. Add a row below the matrix. In B9, count Ana's R tasks:

=COUNTIF(B$2:B$7,"R")

Fill it right to E9. Ben and Dev each have 3 R tasks, while Ana and Chloe have none. In row 10, use "A" instead: Ana is Accountable for 4 tasks, Chloe for 3. A person with many A's and R's is a bottleneck; a person with only I's may not need to be on the project.

For questions about two people at once, use COUNTIFS, which needs every condition to be true. To count tasks where Dev does the work and Chloe owns it:

=COUNTIFS(E2:E7,"R",D2:D7,"A")

The result is 2 (Design mock-ups and Run user tests). The COUNTIFS function guide shows more conditions.

How to colour code the RACI letters#

Colours make the matrix readable in a meeting. Use one rule per letter:

1. Select B2:E7.
2. Go to Home > Conditional Formatting > Highlight Cells Rules > Equal To.
3. Type A, pick a fill such as light red, and click OK.
4. Repeat for R, C and I with their own colours.

To flag whole rows that fail the check, select A2:F7 and add a formula rule (Home > Conditional Formatting > New Rule > Use a formula):

=$F2<>"OK"

The $ before F locks the check column, so every cell in the row looks at its own row's result. The conditional formatting guide explains formula rules in more detail.

Common RACI matrix mistakes in Excel#

Most problems are about the data, not the formulas:

1. Combined letters not counted. If you allow "A/R", "A" won't match it. Count with wildcards: =COUNTIF(B2:E2,"*A*").
2. Spaces after letters. "A " doesn't match "A". The drop-down list prevents this.
3. Too many C's. Consulting everyone slows work down. If a row has more C's than R's, ask whether all of them need a say.
4. No one Informed. Stakeholders who hear nothing tend to ask for status meetings. Add the I's.
5. A stale matrix. Update it when people join, leave or change roles, and keep the check column visible.

Practise it#

The checks in a RACI matrix are COUNTIF and conditional formatting, and both are quick to learn by doing. Practise COUNTIF in a live spreadsheet, then practise conditional formatting rules: you type each step and it checks it instantly. Or try the one-A check in the exercise on this page first.