| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternative for =countifs (in 2007) for Excel 2003
This is my current 2007 formula in Excel 2007:
=COUNTIFS(A4:A302,2,G4:G302,"written") I've tried =COVAR(A4:A302=1,G4:G302="written") But is showing #DIV/0! once completed Thanks for your help... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alternative for =countifs (in 2007) for Excel 2003
See previous thread. NOT good to start a new one
-- Don Guillett Microsoft MVP Excel SalesAid Software "Longhag" wrote in message ... This is my current 2007 formula in Excel 2007: =COUNTIFS(A4:A302,2,G4:G302,"written") I've tried =COVAR(A4:A302=1,G4:G302="written") But is showing #DIV/0! once completed Thanks for your help... |
| Reply |
| 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 | |||
| I need alternative formula for SUMIFS in Excel 2003 | Excel Worksheet Functions | |||
| translating countifs function to Excel 2003 | Excel Worksheet Functions | |||
| COUNTIFS for 2003 | Excel Worksheet Functions | |||
| excel's new countifs...on 2003? | Excel Discussion (Misc queries) | |||
Hybrid Mode
