| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countifs on earlier version of excel
Hello,
I have been working on 2007 excel and used the below formula: =COUNTIFS(JAN!G:G,B14,JAN!B:B,C2) I have just noticed upon saving that this will not work on earlier versions of excel. How do I need to change the formula please to make it compatible? Thanks Aaron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Last saved by earlier version of Excel | Excel Discussion (Misc queries) | |||
| Can I save as an earlier version of excel? | Excel Discussion (Misc queries) | |||
| How do you recover an earlier version of a file in excel. | Excel Discussion (Misc queries) | |||
| Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
| how do i see an earlier saved version of an excel file | Excel Discussion (Misc queries) | |||
Threaded Mode
