V
VIncent
Here is my Excel sheet:
A B C
1 | Task | Duration |
2 | 4 | 1 |TRUE
3 | 4a | 2 |FALSE
4 | 4b | 3 |FALSE
5 | 5 | 4 |TRUE
6 | 5a | 5 |FALSE
7 | | |
I'm looking a formula that would give the total duration
(in B7) of the tasks identified by numerical characters
ie duration of task 4 (1) + duration of task 5 (4).
The only solution I have found so far is to create an
additional column (column C) with the following formula
=ISNONTEXT() and to do: SUMIF(C2:C6,TRUE,B2:B6), which is
equal to 6. I would like to have this result without
having this additional column.
Can someone help me?
Thanks
Vincent
A B C
1 | Task | Duration |
2 | 4 | 1 |TRUE
3 | 4a | 2 |FALSE
4 | 4b | 3 |FALSE
5 | 5 | 4 |TRUE
6 | 5a | 5 |FALSE
7 | | |
I'm looking a formula that would give the total duration
(in B7) of the tasks identified by numerical characters
ie duration of task 4 (1) + duration of task 5 (4).
The only solution I have found so far is to create an
additional column (column C) with the following formula
=ISNONTEXT() and to do: SUMIF(C2:C6,TRUE,B2:B6), which is
equal to 6. I would like to have this result without
having this additional column.
Can someone help me?
Thanks
Vincent