| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
COUNTIF across all sheets of a workbook
On my summary page of a multiple worksheet work book I want to count tihe
number of "Y" responses in the same cell across the entire workbook. I have tried countif(worksheet1:worksheetend!C6,"Y") and it doesn't work.... any help out there? Thanks, Steve |
|
#2
|
|||
|
|||
|
Here is a workaround
http://tinyurl.com/97psj Regards, Peo Sjoblom "Steve" wrote: On my summary page of a multiple worksheet work book I want to count tihe number of "Y" responses in the same cell across the entire workbook. I have tried countif(worksheet1:worksheetend!C6,"Y") and it doesn't work.... any help out there? Thanks, Steve |
|
#3
|
|||
|
|||
|
On Tue, 31 May 2005 16:10:23 -0700, "Steve"
wrote: On my summary page of a multiple worksheet work book I want to count tihe number of "Y" responses in the same cell across the entire workbook. I have tried countif(worksheet1:worksheetend!C6,"Y") and it doesn't work.... any help out there? Thanks, Steve Download and install the free morefunc.xls add-in by Laurent Longre from http://xcell05.free.fr/ and use the COUNTIF.3D function. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF across all sheets of a workbook | Excel Worksheet Functions | |||
| Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) | |||
| How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
| Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
| CountIF across multiple sheets in a workbook | Excel Worksheet Functions | |||
Hybrid Mode
