I appreciate any explanation to this:
I use: =ColorFuction($A$1,B1:B10,FALSE) to count number of cells in B1:B10 that have the same color as cell A1. When I typed in this formula in Excel 07, I alway got #NAME?
I typed in the same formula the other day and it worked fine. Anything wrong with my formula, or do I need to press other key rather than "Enter" key?
Thanks
I use: =ColorFuction($A$1,B1:B10,FALSE) to count number of cells in B1:B10 that have the same color as cell A1. When I typed in this formula in Excel 07, I alway got #NAME?
I typed in the same formula the other day and it worked fine. Anything wrong with my formula, or do I need to press other key rather than "Enter" key?
Thanks