Occurance of data in multiple columns

[Jerry]

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.

 

[JulieD]

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