Quote:
Originally Posted by NBVC
Try:
=SUMIFS(INDIRECT("'year "&RIGHT(F$1,2)&"'!$G:$G"),INDIRECT("'year "&RIGHT(F$1,2)&"'!$B:$B"),$C2,INDIRECT("'year "&RIGHT(F$1,2)&"'!$D:$D"),$D2)
copied across and down
|
Thank you very much for your response.
The formula you sent worked perfectly well in the test attachment I sent at the beginning of the thread however when I used it on the actual document, it did not work and I can't explain why.
Please I need more assistance and I have also attached a copy of the actual document here