Assigned to Count

Lilian Odobor

Please I need help with the formula to count the total number of tasks assigned to each contact on my sheet.

Bassam Khalil

Hi @Lilian Odobor

Hope you are fine, could you please supply a screenshot for your sheet ( remove any sensitive data ) so i can write the exact formula for your sheet.

Lilian Odobor

Please see a sample below. In the Assigned to column, we have three contacts Olayinka, Lilian O. and Lilian E. I would love to count the total number of task assigned to Lilian O, then Olayinka then Lilian E. I used this formula =countif([Assigned to], "Olayinka") but doesn't work.

Lilian Odobor

Hello @Bassam.M Khalil Please see a sample below. In the Assigned to column, we have three contacts Olayinka, Lilian O. and Lilian E. I would love to count the total number of the task assigned to Lilian O, then Olayinka then Lilian E. I used this formula =countif([Assigned to], "Olayinka") but doesn't work.

Bassam Khalil

Hi @Lilian Odobor,

Please try the following formulas:

=COUNTIFS([Assigned to]:[Assigned to], CONTAINS(Contact@row, @cell))

the following is a link to a sample sheet

Lilian Odobor

@Bassam.M Khalil Thank you. I only understand this formula =COUNTIFS([Assigned to]:[Assigned to], CONTAINS(Contact@row, @cell)), from the countif. Contact@row, @cell standard for what?

Lilian Odobor

The result came out as zero.

Lilian Odobor

Bassam Khalil

Hi @Lilian Odobor

Contact@row is to change the contact name in the contact column if you have more contacts to count, so the formula will read the contact whatsoever you write and count the number.

for example, in the future, you add new contact let use say "Bassam K", then you just write this on the cell and the formula will count it directly.

try this in the following sample sheet i created for you please.

Lilian Odobor

Thank you, @Bassam.M Khalil, however, the "Assigned to" Column contain email addresses. Does this apply?

Bassam Khalil

Yes @Lilian Odobor