G Guest Nov 19, 2005 #1 I am doing a template regarding standard usage of an item. It has negative and positve standard usage. How can i add all negative?
I am doing a template regarding standard usage of an item. It has negative and positve standard usage. How can i add all negative?
P Peo Sjoblom Nov 19, 2005 #2 =SUMIF(A1:A100,"<0") -- Regards, Peo Sjoblom (No private emails please)