COUNTIF across sheets in columns

M

meekjj13

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.
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top