sumif function

[toby]

i've several col.s of data.
one col is the quantity of the corresponding items.
if i want to add up the quantity of the items which quantity larger than
"5", then wht should i do ??
thanks in advance

rgds,
Toby

 

[Frank Kabel]

Hi
if column B contains the quantity try
=SUMIF(B:B,">5",B:B)