Hi Folks,
Is it possible to achieve the following?
I want to show the number of weeks remaining from the sum of a column BUT I want it to distinguish between the entry in another column.
See below.
Columns B to L represent a number of weeks
EG1
Column C: Year 1 has a set amount of 47 and C156 displays this.
C157 should display the amount of weeks in Column C but only when a number "1" appears in Column "Y"
C158 displays the total amount remaining
EG2
Column H: Year 2 has a set amount of 38 and H160 displays this.
H161 should display the amount of weeks in Column C but only when a number "2" appears in Column "Y"
C162 displays the total amount remaining
Is this possible?
Thanks
Bookmarks