But your formula works as is. In B1 thru B8 put:

1
2
3
4
5
6
7
8

and in C1 thru E8 put:

data 0 0
0 data 0
0 0 data
0 0 0
0 0 0
0 0 0
0 0 0
0 0 data

and in G1 put:

data

Your posted formula returns 14 (the correct value)
--
Gary''s Student - gsnu200784


"MikeR-Oz" wrote:

Thanks for that.

I am trying to have the formulae refer to to seperate ranges of cells and
refer = to names on a worksheet within the workbook.

I do not think the reference you have provided will assit with this aspect -
but appreciate the support.

Mike

"Gary''s Student" wrote:

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