It gives me " The formula you typed contains an error" message. FYI the sum
of number greater than zero is in column J not c...Sorry but that should not
be the difference.
Thanks
ce
"Bernard Liengme" wrote:
Use SUMPRODUCT
=SUMPRODUCT(--(JAN_05'!$C$2:$C$65536=$A5),--(JAN_05'!$C$2:$C$65536,0),JAN_05'!J$2:$J$65536)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Curtis" wrote in message
...
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