| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Text within Multiple Worksheets
I have a workbook with several sheets. I am trying to determine how many
times "x" appears - using a specific cell (A5) as my reference in each of the sheets. I want to count how many times "x" appears in cell A5 within all the worksheets and summarize on a summary worksheet. So, if I have 9 worksheets that I want to count, I want to know that "x" appears in only 7 of the worksheets. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
| count 2 nonblank cells on multiple worksheets | Excel Discussion (Misc queries) | |||
| Simple Way to Count the Number of Duplicate Dates on Multiple Worksheets | Excel Discussion (Misc queries) | |||
| Same Text on Multiple Worksheets | Excel Discussion (Misc queries) | |||
| Count # of times value "x" appear across multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
