VLOOKUP FOR MULTIPLE VALUES
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 |
It sounds like you could use =sumif().
Debra Dalgleish has lots of info on counting and summing at: http://www.contextures.com/xlFunctions01.html and http://www.contextures.com/xlFunctions04.html RITA wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 09:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com