| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard"
Hi all,
I am trying to find a way to write the following formula in Excel 2003. I have tried SUMPRODUCT but it does not seem to work when both criteria have text values. I tried COUNTIF & COUNTIF but I think the wildcard * is throwing off the result. =COUNTIFS('Cycle 1'!$B$14:$B$1069, "Auto*", 'Cycle 1'!$J$14:$J$1069, "100%") Please help! Thank you! url:http://www.ureader.com/gp/1042-1.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) | |||
![Courtney[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
