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