john.hayes
New Member
- Joined
- Jun 28, 2006
- Messages
- 7
Hi
I am trying to summarise a number of task statuses within a column.
In the below example, the top line shows the summary status of the cells below it (e.g. if some tasks are 'started' and some 'completed', then the overall summary-level status is 'started'). I used the following formula:
=IF(COUNTIF(M11:M17, started)>0, started, IF(COUNTIF(M11:M17, completed)>0, IF(COUNTIF(M11:M17, future)>0, started, completed), future))
Example:
Started
Started
Started
Started
Completed
Completed
Completed
Completed
My difficulty arises in doing the same thing for a number of disconnected cells, i.e. those that are not adjacent to each other. Does anybody have any idea how I can structure the formula to summarise just the fifth and seventh lines for instance?
Thanks loads for your help!
I am trying to summarise a number of task statuses within a column.
In the below example, the top line shows the summary status of the cells below it (e.g. if some tasks are 'started' and some 'completed', then the overall summary-level status is 'started'). I used the following formula:
=IF(COUNTIF(M11:M17, started)>0, started, IF(COUNTIF(M11:M17, completed)>0, IF(COUNTIF(M11:M17, future)>0, started, completed), future))
Example:
Started
Started
Started
Started
Completed
Completed
Completed
Completed
My difficulty arises in doing the same thing for a number of disconnected cells, i.e. those that are not adjacent to each other. Does anybody have any idea how I can structure the formula to summarise just the fifth and seventh lines for instance?
Thanks loads for your help!