I have in column A rows of serial numbers-letters. I have in column B rows of
amounts that correspond with the specific serial numbers-letters in the rows of
column A. What formula would I use to search all the column A cells for, for
example, each of the 1234A cells, and total the corresponding amounts?
1234A1 1 9 (total of all 1234A cells)
1234A2 3 6 (total of all 1234B cells)
1234A3 5 8 (total of all 1234C cells)
1234B1 2
1234B2 4
1234C1 8
Thank you.
---------------------------------
Choose the right car based on your needs. Check out Yahoo! Autos new Car
Finder tool.
