I have a worksheet where I'm try to count the number of items with JobCode=P
and an amount greater than 0. I think I should be able to do it with a
COUNTIF and AND logic but I keep getting errors. Anyone help me with this?
Thanks. Michael

JobCode Amount
P 20
C 10
P 0
P 0
P 10