IsabellaLearning
Board Regular
- Joined
- May 23, 2009
- Messages
- 115
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
=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