| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF Across multiple worksheets for "x"
I am familiar with COUNTIF - I am trying to count the number of times "x"
appears in the same cell of 7 different worksheets in the same Excel file. =COUNTIF(Smith!B7:Jones!B7, "x") I have tried every kind of variation I can think of to make this work. I have tried SUMIF too. If I change the "x" value in the cell to a number "1" - it then works with SUM. Thanks for any insight. I am the IT person helping someone else! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| i have about 100 worksheets, how do i "lookup" multiple criteria | Excel Discussion (Misc queries) | |||
| is it possible to "merge" multiple worksheets into one worksheet? | Excel Discussion (Misc queries) | |||
| can I nest COUNTIF functions(C5:C8,"apples") AND (D5:D8,"green") | Excel Worksheet Functions | |||
| Copy "Page Setup" for multiple worksheets of identical size. | Excel Discussion (Misc queries) | |||
Threaded Mode
