I have an expense report form that contains formulas. When I open the Excel file in Excel 2007, one formula no longer works.
Here is the formula: =CountOfCF(G9:G40,1)
This formula counts the number of red-colored numbers in a block of cells (G9 to G40). The numbers are red because their value happens to be greater than $76.99.
I receive a NAME? error when I open the report in the 2007 version of Excel.
Can anyone help?
Thanks,
Mike
Bookmarks