I'm a beginner to using Excel formulae and have run across a puzzling
problem. Why does my attempt to COUNT the number of entries in column e that
are equal to 5098 when the date is 5/27 give me an incorrect result? I get
"1" but can see that there are at least 2.

Here is a subset of the data:

a b c d e
DATE TIME TRUNK ANI DNIS
5/27/2005 7:32:12 121 5414
5/27/2005 7:32:14 122 5098
5/27/2005 7:32:17 123 5098



Here is the formula:

=COUNT(IF((A2:A500="5/27/2005")*(E2:E500="5098"),E2:E500))

Many thanks.