simple formula for some

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
 
P

Per Jessen

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
 
A

andy

Per - thanks it works well

andy

Per Jessen said:
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



.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top