I want to be able to cut and paste the following formula across my excel table and have it update the row (no column). So `E6:AZ6` would become `E7:AZ7` on the row below, the rest would stay the same.

```
=SUMPRODUCT(COUNTIFS(INDIRECT(FirstYears&"!$E6:$AZ6"),"X",INDIRECT(FirstYears&"!$E$1:$AZ$1"),Weeks))

```

I didn't realise (until lots of searching) that this didn't happen automatically with indirect `functions`. Doh!

I've found lots of possible solutions and I think the row function might help but as I don't know what I'm doing and none of those solutions have been with a range rather than a single cell I have been unable to work out where to put the row command, how to split the current formula and what I need to do about all that crazy punctuation...!

Any help would be gratefully received!