vlookup for a value appearing more than once
 

In a spreadsheet, I have a value which appears more than once in different
rows in a table array. I need to do a vlookup which checks the value in this
table array and sums up the amounts in an adjacent column applicable for this
value. Can I achieve this?
--
rITA
--
rITA

You need to use SUMIF. For an example, see:

http://www.techonthenet.com/excel/formulas/sumif.htm

HTH
Jason
Atlanta, GA

-----Original Message-----
In a spreadsheet, I have a value which appears more than
once in different
rows in a table array. I need to do a vlookup which
checks the value in this
table array and sums up the amounts in an adjacent
column applicable for this
value. Can I achieve this?
--
rITA
--
rITA
.