Counting characters across multiple worksheets

[PaulWhysall]

I'm trying to create a spreadsheet that counts characters (b and b+ for example) across multiple worksheets from specific cells and totals them on a separate worksheet to allow for some data analaysis. I've come up with this =SUM(COUNTIF(INDIRECT("'Child " & ROW(INDIRECT("1:2")) & "'!L8"), "w")) but the cell remains blank (with no error message). Any suggestions as this is far more advanced than my normal SUM etc calculations.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[PaulWhysall]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Thanks for that, I've not been on here for a while. Updated now but I'm using Excel 365 on Windows.

 

[Fluff]

Thanks for that
Your formula works fine for me, are you sure that you have a w in L8 on one of those sheets?

 

[PaulWhysall]

Thanks for that
Your formula works fine for me, are you sure that you have a w in L8 on one of those sheets?

And just like that, something that I had been scratching my head about is sorted.

 

[Fluff]

Glad it's sorted & tanks for the feedback.