Thread: sumif formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Louie Louie is offline
external usenet poster
 
Posts: 40
Default sumif formula

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