welshgasman
Well-known Member
- Joined
- May 25, 2013
- Messages
- 1,393
- Office Version
- 2019
- 2007
- Platform
- Windows
Hi all,
I have a workbook, that we are going to use as an address book for the local community car scheme I volunteer for.
There are tabs for each character of the alphabet.
I want to create a Stats sheet that shows quickly how many are on each sheet.
So in the stats sheet column A, I have values A to Z by using formula =CHAR(ASC(63+ROW()))
I now want to add in column B the COUNTA() of each particular sheet, but refer to cell in column A for the sheet name.
I cannot get the concatenation correct. I have tried = & "COUNTA(" & A2 & "!A:A")-1 and a few other permutations, but just get an error message.
Is it possible to refer to a cell value like this?, and if so, what is the syntax please.?
I know I could just hard code it, as there are only 26, but the logic could come in useful in the future.
TIA
I have a workbook, that we are going to use as an address book for the local community car scheme I volunteer for.
There are tabs for each character of the alphabet.
I want to create a Stats sheet that shows quickly how many are on each sheet.
So in the stats sheet column A, I have values A to Z by using formula =CHAR(ASC(63+ROW()))
I now want to add in column B the COUNTA() of each particular sheet, but refer to cell in column A for the sheet name.
I cannot get the concatenation correct. I have tried = & "COUNTA(" & A2 & "!A:A")-1 and a few other permutations, but just get an error message.
Is it possible to refer to a cell value like this?, and if so, what is the syntax please.?
I know I could just hard code it, as there are only 26, but the logic could come in useful in the future.
TIA
