A good resource for SUMPRODUCT()
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Gary''s Student - gsnu200784
"MikeR-Oz" wrote:
Any one able to assist with formulae like the above which for me is quite
advanced yet I am sure it is intermediate.
I would like to attach a file to give as n example of what I am trying to
do. (How do I do this on the newsgroup?)
Have already got this far from an Excel MVP help and need to expand what I
am doing with a roster.
Any takers??
Mike