Thanks guys - those were all so helpful. I have another question now. How
can I pull multiple information from one column with the same count if. For
instance, what if I want all of the 5/11/09 (column B) that contain these
words in Column D "*assoc*" or "*a.a.s.* or "*management*".

Thanks again!!!

"EJV" wrote:

I have a column with dates and then a column with 1s and 0s. I want to count
how many of the rows that have "5/11/09" in column B also have a "1" in
column BC. I have been reading the suggestions in here and this is the
formula that I have been trying to use. (Note: Sheet 2 contains all of my
data. I am trying to pull it into a report on Sheet 1.) It keeps coming
back with zero, but I know that there are some. I have checked my data to
make sure that it doesn't contain any spaces.

=SUMPRODUCT((Sheet2!B2:B1242="05/11/2009")*(Sheet2!BC2:BC1242="1"))

Thanks a million!!