| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula similar to "countifs" function in excel 2007
I need a formula similar to the countifs function offered in excel 2007. I'm
using excel 2003 and can't upgrade to 2007. I want to add together cars at a particular location. The location names are in one column and the type of car is in another. In 2007, the formula would be =countifs(a2:a5,"new york", b2:b5,"ford"). What can I do to perform the same function in 2003? Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function similar to "LEFT" | Excel Worksheet Functions | |||
| Need function that will work in Excel 2003 like "Countifs" in 2007 | Excel Worksheet Functions | |||
| "countifs" convert to formula in XL2002 | Excel Worksheet Functions | |||
| How do you embed a new line in a formula similar to &" "& but | Excel Discussion (Misc queries) | |||
| I need help with a formula similar to "countif" but more complex | Excel Worksheet Functions | |||
Threaded Mode
