Don't know how to word this. Here is an example of what I'm trying to do.
A1-050-7755 B1-64
A2-BLANK B2-274
A3-030-5555 B3-5
A4-BLANK B4-1
A5-BLANK B5-1
A6-030-4444 B3-6
A7-050-7755 B1-35
In column C I want it to sum up B1 & B2 but not B3 because its a different item. How do I write that formula that will sum up qty's in columnB and stop when it comes to a blank cell in colA.
A1-050-7755 B1-64
A2-BLANK B2-274
A3-030-5555 B3-5
A4-BLANK B4-1
A5-BLANK B5-1
A6-030-4444 B3-6
A7-050-7755 B1-35
In column C I want it to sum up B1 & B2 but not B3 because its a different item. How do I write that formula that will sum up qty's in columnB and stop when it comes to a blank cell in colA.