Shweta
Well-known Member
- Joined
- Jun 5, 2011
- Messages
- 514
Hi All,
Please help me out on the below query
<colgroup><col span="6"><col></colgroup><tbody>
</tbody>
In the result column, I want the sum for the last 4 weeks. If "L" is written in a column then formula should take the value from the next column but the count of the columns should not exceed 4.
For example in first case 0+22+30+28 = 80
in second case 0+7+11+9 = 27.
Please provide me an appropriate formula for this.
Thanks in advance!
Regards,
Shweta
Please help me out on the below query
W5 | W4 | W3 | W2 | W1 | W0 | Result |
28 | L | 30 | L | 22 | 0 | 80 |
8 | 7 | 9 | 11 | 7 | 0 | 27 |
<colgroup><col span="6"><col></colgroup><tbody>
</tbody>
In the result column, I want the sum for the last 4 weeks. If "L" is written in a column then formula should take the value from the next column but the count of the columns should not exceed 4.
For example in first case 0+22+30+28 = 80
in second case 0+7+11+9 = 27.
Please provide me an appropriate formula for this.
Thanks in advance!
Regards,
Shweta