Thread: SUMIF
View Single Post
  #1   Report Post  
Dahlman
 
Posts: n/a
Default SUMIF

I have a worksheet with a list of part #'s and quantities. I have another
sheet totalling all the quantaties because the same part number is listed
multiple times. My formula is:
=SUMIF(RELEASE3!$B$4:$B$1301,B5,RELEASE3!$G$4:$G$1 301)

My problem is this:
I can have part # 15301756, and part # 15301756-5003. But this formula
considers this the same part #. Can someone help me fix this please. Thank
you very much in advance.

Travis Dahlman