Hi Kostis,

Thank you very much for reply and assistance. Unfortunately, your formula did
not provide the expected results. It gave the correct count in some places
but not all.

Bob's formula does provide the expected results.

Cheers,
Sam

vezerid wrote:
Maybe the construct:

OFFSET(Data,ROWS(Data)-70,COLUMN(A:A)-1,70,)

=SUMPRODUCT(--(INDEX(OFFSET(Data,ROWS(Data)-70,COLUMN(A:A)-1,70,),
0,1)=K$15),--(INDEX(OFFSET(Data,ROWS(Data)-69,COLUMN(A:A)-1,70,),0,1)=K
$16)*(INDEX(OFFSET(Data,ROWS(Data)-70,COLUMN(A:A)-1,70,),0,1)<""))

Does this work for you?
Kostis Vezerides

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200804/1