Continuing the sequence

[Phil]

How can i continue the following sequence without having to type it
all out as there are 500 cells to complete?

=SUMPRODUCT(--(B5:B10=B27:H27))
=SUMPRODUCT(--(B5:B10=B28:H28))
=SUMPRODUCT(--(B5:B10=B29:H29))

I want B5:B10 to remain in all but other B values to increase by 1
every time.

Thanks

 

[Andy Brown]

How can i continue the following sequence without having to type it

all out as there are 500 cells to complete?

Try

=SUMPRODUCT(--($B$5:$B$10=B27:H27))

HTH,
Andy

 

[Phil]

You, Sir, are a timesaver. Many thanks

Try

=SUMPRODUCT(--($B$5:$B$10=B27:H27))

HTH,
Andy