Formula to Point to a Designated Sheet and perform Calcs

[hammer2]

Hi Folks

I need a formula to point to a designated sheet that is defined by a name in Col C and then to perform SUMIFS and COUNTIFS calcs.

Example supplied.

Regards
hammer

[shukla.ankur281190]

try

DN2=SUMIFS(INDIRECT("'"&TRIM(C2)&"'!"&"P:P"),INDIRECT("'"&TRIM(C2)&"'!"&"F:F"),F2,INDIRECT("'"&TRIM(C2)&"'!"&"G:G"),G2,INDIRECT("'"&TRIM(C2)&"'!"&"DI:DI"),1)-COUNTIFS(INDIRECT("'"&TRIM(C2)&"'!"&"F:F"),F2,INDIRECT("'"&TRIM(C2)&"'!"&"G:G"),G2) and drag down

[hammer2]

Works perfectly!
Thank you very much Ankur Shukla !