Hi Jerry
one method
assuming your format is
.........A.................B..................C
1....Month..........Day...............Year
2...Jan.................5...................2005
3...Jan................3....................2005
=SUMPRODUCT(--(A2:A9&B2:B9&C2:C9="Jan52005"))
Cheers
JulieD
"Jerry" wrote in message
...
I have three columns of data. I want to count how many
times all three have specific values. For example,column
A is Day, column A is month, column B is day and column C
is year. How many times will a specific month, day and
year be found.
|