Assume date in A5:A100, Site 1,2,3,4.... in B5:Z100
A1: is the user to enter date

B1: =SUMPRODUCT((A5:A100=A1)*(B5:Z100="XP"))


"Carlee" wrote:

Hello I have a data sheet that looks likes this:

Reading Date Site 1 Site 2 Site 3 Site 4 .....
Jun 1,2007 XP XP D XP
Jun 2, 2007 XP D D P

Question:
I want use a function that will enable the user to enter a date, and the
function will search for that date, and count the number of times the code
XP, is entered.

Can anyone help me out with my quest?
--
Carlee