Consolidate working formula

[devid3an]

Hi Guys

I would like to consolidate this formula , it does work.
I think I could use productsum?

=INDIRECT("'"&B2&"'!"&"J13")+INDIRECT("'"&B2&"'!"&"J23")+INDIRECT("'"&B2&"'!"&"J33")
Any help would be appreciated

thanks

[wk9128]

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information

Try

Please Login or Register  to view this content.