Hi

you need to use the SUMPRODUCT function
=SUMPRODUCT(--(A1:A10="P"),--(B1:B100))

check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

for details on how this works

cheers
JulieD


"mlkpied" wrote in message
...
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