I have the following formula in one column:
=IF('C:\[Test.xls]Tab1'!$T4="x",'[Test.xls]Tab1'!G4,"")
This formula results in a date value being placed in each cell of this column where the source file has an "x". This is all working just fine.
Results are being placed in Column E:
13-Mar
14-Mar
14-Mar
15-Mar
etc.....
Then I have a simple countif function to count those up and tell me how many of each there are. It looks like:
=COUNTIF(E:E, H2)
H
Date Total
13-Mar 0
14-Mar 0
15-Mar 0
So the value of Total should be 1 for 13-Mar in this example, followed by 2 for 14-Mar, and 1 for 15-Mar.
The CountIF seems like it's treating the resulting value in column E as the formula itself instead of the result of the formula. In fact, when I replaced 13-Mar with the formula that gives me that value, then it counts it.
I hope that makes sense. All in all, it seems like its not counting the formula result ...
HELP!!!!
P.S. This is all happening in the NEW version of Excel (Office 2007), with the older version this was all working just fine.
Bookmarks