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

Hi Andy

Try this (simple) formla:

=SUMPRODUCT(--(C1:C100=100%),--(A1:A100=B1:B100))

Adjust ranges as required, just remeber they has to be same size.

Regards,
Per

"andy" skrev i meddelelsen
...
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

Per - thanks it works well

andy

"Per Jessen" wrote:

Hi Andy

Try this (simple) formla:

=SUMPRODUCT(--(C1:C100=100%),--(A1:A100=B1:B100))

Adjust ranges as required, just remeber they has to be same size.

Regards,
Per

"andy" skrev i meddelelsen
...
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


.