A
andy
Hi - I hope someone can help with a formula problem- with 3 columns covering
dates/ date ranges and using another for a % complete figure
I have 1 column with a range of week dates covering 6 mths ( Col A)
I have 1 column with lots of dates ( Col B) and another with a % complete
figure ( Col C) against the dates
what i would like to do is a "count if" ( or something similar - help) for
the following
in a seperate cell - I would like col B to "look" at Col A and count the no
of times this date is the same but only if the date in Col C i= 100% .
any ideas would be grateful
thanks andy
in another 2 columns i have dates when a activity was completed and in
another I have a 100% column when the activit
dates/ date ranges and using another for a % complete figure
I have 1 column with a range of week dates covering 6 mths ( Col A)
I have 1 column with lots of dates ( Col B) and another with a % complete
figure ( Col C) against the dates
what i would like to do is a "count if" ( or something similar - help) for
the following
in a seperate cell - I would like col B to "look" at Col A and count the no
of times this date is the same but only if the date in Col C i= 100% .
any ideas would be grateful
thanks andy
in another 2 columns i have dates when a activity was completed and in
another I have a 100% column when the activit