vlookup

[Aloyisius]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I have one column with numerical values between 1 and 50 and an adjoining one with monetary values. The numerical values may occur once or they may repeat at random. The monetary values differ with each instance. A 10 could =$350 and another 10 could = $234. I would like to be able to add up all the monetary values of like numerical values. I have tried =vlookup(10,M:N,false) with 10 being the numeric value, but that only returns a single value for 10 instead of adding up all the 10's monetary values. Please advise. Thanks.

 

[Niek Otten]

Look in HELP for the SUMIF() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Version: 2008
| Operating System: Mac OS X 10.5 (Leopard)
| Processor: intel
|
| I have one column with numerical values between 1 and 50 and an adjoining one with monetary values. The numerical values may
occur once or they may repeat at random. The monetary values differ with each instance. A 10 could =$350 and another 10 could =
$234. I would like to be able to add up all the monetary values of like numerical values. I have tried =vlookup(10,M:N,false) with
10 being the numeric value, but that only returns a single value for 10 instead of adding up all the 10's monetary values. Please
advise. Thanks.

 

[Alan Letts]

Thank you for the advice. I knew it was something simple like that but I couldn't quite remember. Thanks again.