XL2007

=SUMIFS(P:P,L:L,"HCAIN",P:P,"0")


"Louie" wrote:

Hello, I made a formula that looks like this, =SUMIF(L:L,"HCAIN",P:P)
however, I need it to sum only the positive numbers and ignore the negative
numbers, I am missing something in it and I cant figure it out.
thank you for your help!
--
Louie