Hello everyone,
I have this situation:
=IF(Bdg!$B$9=1,Sch!AJ8+Sch!AN8, IF(Bdg!$B$9=2,Sch!AJ16+Sch!AN16, IF(Bdg!$B$9=3,Sch!AJ24+Sch!AN24, ..., IF(Bdg!$B$9=12,Sch!AJ96+Sch!AN96)
where Bdg(B9) has the number of the current month and Sch(AJ+AN) have values to add up in a pattern of 8 rows apart for...