I need to sum up data using the first three letters as the ref point across multiple sheets, I have the current formula but it does not work, any other options?
Thank you
=SUMIF(LEFT(INDIRECT("'PL "&R$16&"'!$A:$A"),3),'Monthly Pos PnL Admin Data-->'!$A61,INDIRECT("'PL "&R$16&"'!$G:$G"))
The INDIRECT function references a monthly sheet where the data exists but need to be able to drag across to pick up data from multiple months which is why using INDIRECT function
Any help appreciated!!
Thank you
=SUMIF(LEFT(INDIRECT("'PL "&R$16&"'!$A:$A"),3),'Monthly Pos PnL Admin Data-->'!$A61,INDIRECT("'PL "&R$16&"'!$G:$G"))
The INDIRECT function references a monthly sheet where the data exists but need to be able to drag across to pick up data from multiple months which is why using INDIRECT function
Any help appreciated!!