Count If Formula

Nick.C

Hi there,

I am trying to look up a WBS number from a cell in a column and count the number of times it appears in another column with the status of either "blocked", "work in progress" or "Not Started"

The first criteria seems to work (i.e. the bit that counts the blocked", "work in progress" or "Not Started"), but the second criteria fails. I want to link the 2nd criteria to a cell in a column which has a number.

Any pointers would be much appreciated.

Thanks in advance.

Nick

Paul Newcome

It looks like you need to move the curly bracket at the end to after the 1 to close out the range before starting the criteria.

Paul Newcome

It looks like you need to move the curly bracket at the end to after the 1 to close out the range before starting the criteria.

Nick.C

Many thanks Paul.

That worked!

Nick :-)

Paul Newcome

Happy to help. 👍️