Look in vain, you won't find it, it is an evolution driven by experienced
Excel users.

Bob

"Laddy" wrote in message
...
Just to say that the suggested solution work well and I have adapted it to
suit my needs after understanding how it works.
This form of SUMPRODUCT is not in my Excel 97 guide so I must presume it
will be in a later publication. I shall now try to find out.

Thanks

Laddy

"Max" wrote in message
...
You're welcome !
Thanks for posting back ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Laddy" wrote in message
...
Thanks lads I shall now have a bash at doing the job
Good luck to you all

Laddy