extending formula

[jackhays]

Hi everyone. Hope someone is willing to help me out

It still has something to do with irregular extension of a formula. The formula is supposed to count the number of times a certain combination is made. So I started out with the basic =AND(COUNTIF(A1,"Yes"))*(COUNTIF(A2,"On time")), the next comparison I want it to make to see if it should count it is: =AND(COUNTIF(A4,"Yes"))*(COUNTIF(A5,"On time")) and then onwards to A7 and A8 and so on. I hope I am clear enough

Thanks a million!

[TMS]

Try:

Please Login or Register  to view this content.

Regards, TMS