| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countin Numbers in a Workbook
I am trying to find a funciton that counts the number of times a number shows
up in various locations in a worksheet and also on multiple worksheets within a workbook. I.E. How many times does "171" appear in mutliple worksheets in one worbook? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Countin Numbers in a Workbook
If the target ranges are located at the same place on each sheet, for
example D2:D100 on each sheet, try... =SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$2:$A$4&"'!D2:D 100"),"171")) ....where A2:A4 contains the sheet names. Hope this helps! In article , Matt wrote: I am trying to find a funciton that counts the number of times a number shows up in various locations in a worksheet and also on multiple worksheets within a workbook. I.E. How many times does "171" appear in mutliple worksheets in one worbook? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i see sum of numbers at bottom of workbook | Excel Worksheet Functions | |||
| Multiple workbook sheet numbers! | Excel Worksheet Functions | |||
| Copying store numbers and pasting them into a seperate workbook | Excel Discussion (Misc queries) | |||
| Continuous page numbers in workbook of multiple worksheets | Excel Discussion (Misc queries) | |||
| Countin Dates | Excel Worksheet Functions | |||
Linear Mode
