You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"jeannie v" wrote in message
...
Hi Biff: My bad.....I think I found the error....It seems to work
perfectly....If I have any other problems, I will post again...

Thank you for your expertise....
--
jeannie v


"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(Sheet1!A1:A10="ABCD"),--(Sheet1!H1:H10="Dummy"),--(ISNUMBER(Sheet1!I1:I10)),--(Sheet1!I1:I100))

If column I will contain only numbers or empty cells then you can
eliminate
the ISNUMBER test.

=SUMPRODUCT(--(Sheet1!A1:A10="ABCD"),--(Sheet1!H1:H10="Dummy"),--(Sheet1!I1:I100))


--
Biff
Microsoft Excel MVP


"jeannie v" wrote in message
...
Hi Experts: I've done this before but it's been quite a while and I'm
having
trouble getting the results I want....This is what I want to do: On
Worksheet 1, If Column "A" = "ABCD" and Column "H" = "Dummy", Count
Occurrences in Column "I" If Greater Than "0" and Enter in Cell "G4"
on
Worksheet 2.

Could someone tell me how to do this?

Thank you for any help you can provide
--
jeannie v