Countif for 2 things - once per name and then + 1 each time it sees a word "all"

[IsabellaLearning]

Currently I am counting how many outstanding tasks there are for each team member as per:
=COUNTIF('Outstanding'!C:C,I3)

All outstanding tasks are in a tab called outstanding with the names of the people in column C and in Column "i" in a separate sheet have the sheet with the tallys

If all works fine but I also now want that then in column see the word "ALL" appears it also counts as "1" more task to each individual - does that make sence? Currently countif is counting how many times each name appears, i also want it to add "1" more each time the work "all" is in the column

thankyou
Isabella

 

[Steph77]

Try:

=COUNTIF('Outstanding'!C:C,I3)+COUNTIF('Outstanding'!C:C,"ALL")

 

[ztodd]

You want to look for the word "all" in which column? Sounds like you just need to add the result from another COUNTIF, like this- COUNTIF('Outstanding'!C:C,I3)+COUNTIF(...fill in what you need here...)

You can do pattern matching with the COUNTIF. Put your cursor on the COUNTIF and press F1 to see how.

Guess I was too slow. and I guess I misunderstood you anyway.

 

[IsabellaLearning]

Thankyou ztodd, i really appreciate your help, too much feedback is never enough

 

[IsabellaLearning]

Steph! right on the money thankyou so much im up and away now!
very much appreciated