Formula to capture a total amount of items in a cell.

Orlando Mercado

I am looking for a formula that will give me the total number of items listed under benefits for a project.

For example, =COUNTM([Project A]:[Project A], Benefits:Benefits])

We currently have 17 benefits that can be selected in each project. I this particular project, only 2 benefits apply.

Jeff Reisman

@Orlando Mercado

To get the count of items in the benefits cell for each row, you just need:

=COUNTM(Benefits@row)

Jeff Reisman

@Orlando Mercado

How is your data structured? Does each Project have its own row? Is the Benefits column a multi-select column?

With your current formula, if both Project A and Benefits are multi-select columns, COUNTM will count the total number of choices selected in both columns. So if you have values of Project A1, Project A2, and Project A3 selected, and each has 4 different values selected in Benefits, your formula would return 15 - that is, 3 from the Project A column and 12 from the Benefits column.

Orlando Mercado

This is how my data is structured. Yes, each project has its own row. The benefits column is a multi section column.

Jeff Reisman

@Orlando Mercado

To get the count of items in the benefits cell for each row, you just need:

=COUNTM(Benefits@row)

Orlando Mercado

That worked! Thank you.