Sum of multiple VLOOKUPs in a single cell
tranquille0123
Posted messages
2
Status
Membre
-
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
Hello,
I want to sum several HLOOKUP or VLOOKUP in a single cell, instead of doing:
=HLOOKUP(...)+HLOOKUP(...)+HLOOKUP(...).......
Thank you
Configuration: Windows XP / Firefox 16.0
I want to sum several HLOOKUP or VLOOKUP in a single cell, instead of doing:
=HLOOKUP(...)+HLOOKUP(...)+HLOOKUP(...).......
Thank you
Configuration: Windows XP / Firefox 16.0
4 réponses
You can perhaps use a SUMIF
=SUMIF($A$6:$A$20;$A6;$B$6:$B$20)
instead of VLOOKUP to find an element and take the value from a column
we sum values that meet one or more criteria.
=SUMIF($A$6:$A$20;$A6;$B$6:$B$20)
instead of VLOOKUP to find an element and take the value from a column
we sum values that meet one or more criteria.
Hello,
it is indeed possible to perform sums of VLOOKUP() or HLOOKUP() in a single cell.
But one must not forget that the result of this kind of function is in text format, even if you are returning numbers. To get a result in number format, you must wrap the lookup function with the VALUE() function.
To sum them up, the syntax is therefore:
=VALUE(HLOOKUP(...)) + VALUE(HLOOKUP(...)) + ... + VALUE(HLOOKUP(...))
Best regards.
--
That guy wasn't too bright, as he was naive.
it is indeed possible to perform sums of VLOOKUP() or HLOOKUP() in a single cell.
But one must not forget that the result of this kind of function is in text format, even if you are returning numbers. To get a result in number format, you must wrap the lookup function with the VALUE() function.
To sum them up, the syntax is therefore:
=VALUE(HLOOKUP(...)) + VALUE(HLOOKUP(...)) + ... + VALUE(HLOOKUP(...))
Best regards.
--
That guy wasn't too bright, as he was naive.
Thank you very much for your prompt response,
BUT I don't want to pull up the VLOOKUP table every time, I just want to do VLOOKUP( ...sum of several cells) once, in fact summing several No_index_col
Thank you
BUT I don't want to pull up the VLOOKUP table every time, I just want to do VLOOKUP( ...sum of several cells) once, in fact summing several No_index_col
Thank you
