| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIFS Function
I have a spreadsheet with countries in one column. I am trying to count the
number of times Armenia and Azerbaijan appear in this one column as a total. I am using this function =COUNTIFS('[Member List(1).xls]Sheet1'!$C$2:$C$1108,"azerbaijan",'[Member List(1).xls]Sheet1'!$C$2:$C$1108,"armenia") where Member List is the name of my spreadsheet and the range I want to counted is C2:C1108. Cans omeone please tell me where I'm going wrong? Much appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need function that will work in Excel 2003 like "Countifs" in 2007 | Excel Worksheet Functions | |||
| translating countifs function to Excel 2003 | Excel Worksheet Functions | |||
| Countifs Fx in 07 how in 03? | Excel Discussion (Misc queries) | |||
| countifs | Excel Discussion (Misc queries) | |||
| 2 COUNTIFS | Excel Discussion (Misc queries) | |||
Threaded Mode
