linking a sumif and a if (qty) formula

T

Tom Edwards

I have a list of 3000 items that I would like to breakup
into 4 different quanties. 1-2, 3-5, 6-10, and 10+.I need
to know how I can link
=sumif(D$2:D$3000,$B3002,M$2:M$2:M$3000) into the same
formula.
 
Top