I have two columns of figures (1 is segmented) and wish to sum column "B" if a number in the segmented column 'A' fits criteria. I need to tell the program that it needs to look at just the third segment of the Column 'A' . Eg if the third seg states 05 it sums the corresponding $value in column 'B'.
Can anyone help?
Column A Column B
2-10-05-3628-701 $19.00
2-10-05-3179-701 $19.00
2-10-05-3628-701 $8.35
2-10-05-3179-701 $8.35
2-10-05-3628-701 $9.85
Bookmarks