Excell page range help

[cruizectrl]

Hey everyone.. I got my answer for my previous post about getting a formula to count up instances in 2 columns by useing the SUMPRODUCT action.. But now I'm running into another brick wall.. So far here is my formula

=SUMPRODUCT((Wk52!$A2:$A99=System!D4)*(Wk52!$D2:$D99=System!F2))

Now this is counting up the rows where in 2 columns the data is matching what is specified in the systems page in the specified cell. Now I want to take that same formula and spread is out from Wk1 to Wk 52 (52 pages)

When I do that the formula looks somthing like this
=SUMPRODUCT((Wk1:Wk52!$A2:$A99=System!D4)*(Wk1:Wk52!$D2:$D99=System!F2))

When I do that I get a #REF error..
What gives?!

(I also tried putting quotes in as well..)

As soon as I get this one figured out I am home free.

 

[xlbo]

Should we infer from this that you have 52 seperate sheets....one for each week ???
This being the case, you can't do it the way you are trying at the mo.
Please confirm or reject this assumption and we'll see what we can do...

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes