Help with sumprodct

N

NH

I have the following formula and it works fine
=SUMPRODUCT(--(Jan04!B9:B55=$A$1),(Jan04!F9:F55))

However when i change the sheet name Jan04 with Indirect(F1)&!B9:B55 it
gives me an error message
Cell F1 above has date "Jan04"

Please help in resloving the formula
 
N

NH

Thanks frank It works great However when i copy the cells to next column the
reference do not change for instance f9should have become G9
But that the easy part and can be manually done
Thanks again you saved me a ot of time
 
F

Frank Kabel

Hi
then try:
Indirect("'" & F1&&"'!" & CELL("Address",B9) & ":" &
CELL("address",B55))
 
Top