| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard"
I'm getting a "#DIV/0" error.
Do you have #DIV/0! errors in any of the referenced ranges? Try this array formula** : =SUM(IF(LEFT('Cycle 1'!B14:B1069,4)="Auto",IF(ISNUMBER('Cycle 1'!J14:J1069),IF('Cycle 1'!J14:J1069=1,1)))) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Courtney" wrote in message .. . Hi thanks for your quick response. I'm getting a "#DIV/0" error. Soemthing must be wrong because when I use COUNTIFS in 2007, the result is 26. Any ideas of what could be causing this error or what could fix the formula? url:http://www.ureader.com/msg/104258258.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula similar to "countifs" function in excel 2007 | Excel Worksheet Functions | |||
| Excel Equivalent of Access "Load" Event? | Excel Discussion (Misc queries) | |||
| "Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
| Need function that will work in Excel 2003 like "Countifs" in 2007 | Excel Worksheet Functions | |||
| Is there an Excel 2003 equivalent to Word's "versions" function? | Excel Discussion (Misc queries) | |||
Threaded Mode
