Reference cell with Worksheet name in a formula

[JeannetteE]

My formula is: "=SUM(COUNTIFS('01 Platform'!$I:$I,"",'01 Platform'!$D:$D,{TRUE}))", this is in cell D19. The name of the worksheet is in B19, I would like to reference that cell instead of using the worksheet name in the formula as I have additional rows to apply that formula and just want to fill down rather then replace each worksheet name.

Hope that makes sense and any help is appreciated.

 

[KOKOSEK]

=INDIRECT("'"&B19&"'!D19")

 

[JeannetteE]

=INDIRECT("'"&B19&"'!D19")

Thanks but that doesn't work, it gives me a TRUE result. I need the result to be a count based on the criteria in the formula, I just want to replace the worksheet name with the value in B19.

 

[mohadin]

Hi
Try

=SUM(COUNTIFS(INDIRECT("'"&B19&"'!I:I"),"",INDIRECT("'"&B19&"'!D:D"),{TRUE}))

 

[KOKOSEK]

Sorry misunderstanding:

=SUM(COUNTIFS(INDIRECT("'"&B19&"'!$I:$I"),"",INDIRECT("'"&B19&"'!$D:$D"),{TRUE}))

 

[JeannetteE]

Sorry misunderstanding:

=SUM(COUNTIFS(INDIRECT("'"&B19&"'!$I:$I"),"",INDIRECT("'"&B19&"'!$D:$D"),{TRUE}))

Thank you, that works.

 

[JeannetteE]

Hi
Try

=SUM(COUNTIFS(INDIRECT("'"&B19&"'!I:I"),"",INDIRECT("'"&B19&"'!D:D"),{TRUE}))

Thank you, this also works