Use Countif to count the number of tasks assigned to a worker?

Valencia C.

Hi, I'm sure there is a quite dimple solution to the this, but I am having trouble.

I want to count the number of rows assigned to each contact, and I used the formula below:

=COUNTIF(Assigned Work:Assigned Worker, "contactname")

The formula returns the error #UNPARSEBALE

How can I fix this?

Paul Newcome

Whenever a column name contains a space, special character, or number, the column name should be wrapped in [Square Brackets].

 

=COUNTIF([Assigned Work]:[Assigned Worker], "contactname")

Valencia C.

Thank you for responding Paul,

But even after adding the square brackets, it still returns an error.

Andrée Starå

Hi Valencia,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

Check your column names. You have one as "Assigned WORK" and the other as "Assigned WORKER". If you are only referencing one column, then one of those column names is incorrect.

 

My apologies for not catching that the first time.

Andrée Starå

Paul,

Nice catch!

I didn't see it either. Some combinations are hard to spot. Probably some science to it. 

Paul Newcome

I've done the same thing to myself a few times and then spent hours trying to figure it out. That's why I have gotten into the habit of clicking on the cells themselves. That way I KNOW the column names are correct. If I am doing a column reference, I will select a few cells within the column and then just delete the row references.

 

If that's any clue how often I messed the column names out, I had to change my "standard practice" in formula writing to account for my fat fingers. LOL

Andrée Starå

Haha! 

If something isn't working, then check what fat fingers did!

Paul Newcome

Pretty much sums it up. Hahahaha

Valencia C.

Thank you both so much!

Paul Newcome

Happy to help! 

Andrée Starå

Happy to help!

Best,

Andrée