Hi,
Ive seen a few threads but cant quite get what i'm after.
I have this formula on a summary sheet;
Problem is i want it to go across sheets 'Week 1' to 'Week 53', next issue is that not all the weeks sheets are there and thay are added in on a weekly basis.
Is there a formula for this or an easy code that could do the job ?
Thanks,
Garth
Ive seen a few threads but cant quite get what i'm after.
I have this formula on a summary sheet;
Code:
=SUMPRODUCT((RIGHT('Week 10'!$D$3:$D$300,8)=Sheet1!H$1)*('Week 10'!$B$3:$B$300=Sheet1!$A2)*'Week 10'!$G$3:$G$300)
Problem is i want it to go across sheets 'Week 1' to 'Week 53', next issue is that not all the weeks sheets are there and thay are added in on a weekly basis.
Is there a formula for this or an easy code that could do the job ?
Thanks,
Garth