|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 9th, 2010, 09:25 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF across sheets in columns
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. 
|
|
#2
March 10th, 2010, 01:00 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
