Superb Richard. That's exactly what I was after.

Not used SUMPRODUCT before. Just the job.

Thanks ever so much.

Mike (also in Cheshire, UK)


"Richard Buttrey" wrote in
message ...
[ snip ]

The following in F2 and copied down seems to work for me.

=SUMPRODUCT((B2:E2<"")*(B$7:E$7-B2:E2+1))

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________