View Single Post
  #1   Report Post  
Curtis
 
Posts: n/a
Default Conditional SUMIF

I am currently using the formulae to clcualte the sum for $A5

=SUMIF(JAN_05'!$C$2:$C$65536,$A5,JAN_05'!J$2:$J$65 536)

I would to modify this so it leaves out all numbers less than 0

Thanks