Iam still having problems. I have added more specific detail as follows:
Column A Column B
1 C016469739 42,511
2 C016469738 5,360
3 C016469737 34,770
4 C016469738 3,318
5 C016469737 22,985
6 C016469737 2,575
7 C016469739 8,575
Current formula Used
=SUMIF($A$1:$A$7,A1,$B$1:$B$7)
What I need to do is summarize the total volume in column B with the like PO #'s from column A. Not having any success. Can someone advise?
Regards.....ROBITMP
Column A Column B
1 C016469739 42,511
2 C016469738 5,360
3 C016469737 34,770
4 C016469738 3,318
5 C016469737 22,985
6 C016469737 2,575
7 C016469739 8,575
Current formula Used
=SUMIF($A$1:$A$7,A1,$B$1:$B$7)
What I need to do is summarize the total volume in column B with the like PO #'s from column A. Not having any success. Can someone advise?
Regards.....ROBITMP