COUNTIF across sheets in columns
You can put a COUNTIF function in the same cell in each of those 32
sheets, eg in cell X1:
=COUNTIF(K:K,Summary!A1)
where the name is specified in cell A1 of your summary sheet. Then in
B1 of the summary sheet you could have:
=SUM('Sheet1:Sheet32'!X1)
assuming your sheets 1 to 32 are arranged contiguously.
Hope this helps.
Pete
On Mar 9, 9:25*pm, meekjj13
wrote:
I am trying to count names that appear in multiple sheets. *All of the names
appear in the column K in 32 sheets. *Is there away to do this? *Thanks for
any help.
|