Sumif Indirect

[olivergs1982]

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 = Employee Ref Number Range going down
DK3:DK691 = Employee Pension Totals going down

Trying to have a sheet so that I can reference data across a range of months, hence wanting to indirect to Row 8 for each month as it happens.
Thanks for any help!

 

[steve the fish]

Re: Sumif Indirect HELP

Hi. You were nearly there but not quite:

=SUMIF(INDIRECT("'"&$C8&"'!$AH$3:$AH$691"),$A9,INDIRECT("'"&$C8&"'!DK$3:DK$691"))

You are building a string to pass to INDIRECT. This string in the first indirect is now:

'April2018'!$AH$3:$AH$691

which is what you need.