How do I show data from 2 rows in the same sheet returning the same information

JessMc3

Example all of this information is contained in the same sheet

Role 1 - staff 1 is an Administrator

Role 2 - staff 2 is a Scheduler

I want to ensure for each role that I am counting both rows (Role 1 and Role 2)

Andrée Starå

@JessMc3

This is for both columns.

=COUNTIF([Staff 1 - Role]:[Staff 1 - Role], "Administrator") + COUNTIF([Staff 2 - Role]:[Staff 2 - Role], "Administrator")

For the row.

=COUNTIF([Staff 1 - Role]@row, "Administrator") + COUNTIF([Staff 2 - Role]@row, "Administrator")

Did that work?

Michael Culley

So you want a way to check if both columns show the same role for any given row?

What about making a checkbox column with the formula:

=if([Role1]@row = [Role2]@row,1,0)

Andrée Starå

Hi @JessMc3

I hope you're well and safe!

Not sure I follow. Can you elaborate?

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

JessMc3

@Michael Culley would this actually count the total number of schedulers in each column?

Michael Culley

@JessMc3

Are you just wanting to count how many Admins, Schedulers, etc you have total?

And you want to count both columns in that formula?

JessMc3

@Andrée Starå I have a sheet where we have 5 columns for each staff member so 10 total columns

i want to count the number of times scheduler appears in role 1 for staff and in role 2 for staff. my boss wants a total count for the role.

Occasionally the row itself might contain a scheduler and an administrator. I would like to count each of those

Andrée Starå

@JessMc3

Ok.

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

JessMc3

@Michael Culley yes. data for 2 staff members is in the same row and may contain 2 different roles. ex scheduler and office manager.

my boss wants a count of each for the sheet.

Michael Culley

@JessMc3

So like:

=countif([Role1]:[Role2],"Scheduler")

Does that work?

JessMc3

@Andrée Starå these two columns within the same row.

looking for an accurate count of each title

Andrée Starå

@JessMc3

This is for both columns.

=COUNTIF([Staff 1 - Role]:[Staff 1 - Role], "Administrator") + COUNTIF([Staff 2 - Role]:[Staff 2 - Role], "Administrator")

For the row.

=COUNTIF([Staff 1 - Role]@row, "Administrator") + COUNTIF([Staff 2 - Role]@row, "Administrator")

Did that work?