You can enter your PO's in a column, and then in the next column enter a

SumIf() formula that will reference the cells containing the PO's, so that

they'll be side by side.

For example, with 1006 in A9,

And 1003 in A10, enter this formula in B9, and copy down:

=SUMIF($A$2:$A$6,A9,$B$2:$B$6)

--

HTH,

RD

=====================================================

Please keep all correspondence within the Group, so all may benefit!

=====================================================

I have a table, listed below, and i need to return the sum of the matching

cells from the lookup. i think its explained pretty well below. The

vlookup

formula stops after it finds the first match. i need it to find all matches,

sum them, and return to the cell.

A B C D E

1 PO# AMT

2 1003 75

3 1003 33

4 1006 21

5 1003 19

6 1006 67

Need to return:

Cell A9 -- 1006 - 88

Cell A10 -- 1003 - 127

Currently using the vlookup formula i can only return 75 for PO 1003. this

is because it is the first value listed.

Any clues on how to return all values next to PO 1003 and sum them??

Many thanks.