OK...I am trying to enter a formula that is based on several
criteria....criteria that is derived from different columns of a different
worksheet. I assume this is possible, let me try and explain...

On one worksheet, I would like to have a formula that counts cells of
another worksheet that have data in them, but only if a few criteria are
satisfied in each row of the 2nd worksheet. For example, I want to generate a
number of entries in column C, only if column B and/or A meet certain
criteria for each specific row in that same worksheet. So, in cell C1, I
would like to know if there is some data present, but only if cell B1 meets
certain criteria and A1 meets certain criteria (say the date in A1 must be
todays date, otherwise I don't care...or the name in B1 must be a certain
name). And, suppose we are talking about the first 5 rows...so I am
ultimately looking for a SUM. How would I show that column C SUM in a
specific cell on another worksheet?

I hope I explained that well enough. Thanks in advance for any help!!!