I've scoured the forums and seen this posted before but I still can't get mine to work. Workbook: Pension Calculations.
Formula= SUMIF(INDIRECT("$C8&""!$AH$3:$AH$691"),$A9,(INDIRECT("$C8&""!DK$3:DK$691")))
C8 = April2018 Sheet name is April2018
A9 = Employee Ref Numbers going down
AH3:AH691 =...