| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Why Does This Formula Return an Error??
 Hi, what am I doing wrong with the following formula:=countif(sheet1:sheet31!E6:E35,"=1") FOR some reason this formula fails when I use the (sheet1:sheet31) with the column range (E6:E35). Is it possible to include a multiple sheet count and column range in the same Formula? Thanks for any helpful responses.. By the way, the formula works ok just as long as I'm not trying to read multiple sheets.. Please help on this. -- Mhz ------------------------------------------------------------------------ Mhz's Profile: http://www.excelforum.com/member.php...o&userid=35980 View this thread: http://www.excelforum.com/showthread...hreadid=558346 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error in vlookup formula | Excel Worksheet Functions | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula Pop Up Error Msgs | Excel Discussion (Misc queries) | |||
Threaded Mode
