Occurance of data in multiple columns
 

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.

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.