Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif compares to Countifs
How can I use a count function in excel 2003 that does the same thing as
countifs in Excel 2007? I created this multi criteria in Excel 2007 but it wont work in Excel 2003 as the rest of the team dont have the same version and it converts to #NAME?. I am trying to count the number of times where a particular criteria has been used e.g. 12 Mth where there is a date in column AC =_xlfn.COUNTIFS($AB$3:$AB$150,"12 mth",$AC$3:$AC$150,"0") How can I use mutilpe criteria in Excel 2003 to do the same thing? -- kje.1953 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fix EXACT function so it always compares in the same row. | Excel Worksheet Functions | |||
Replacing COUNTIFS with COUNTIF | Excel Worksheet Functions | |||
create a macro that compares two workbooks | Excel Discussion (Misc queries) | |||
Function that compares dates | Excel Worksheet Functions | |||
formula that compares different ranges | Excel Worksheet Functions |