vlookup with sum (1 Viewer)

Muaz

Registered User.
Local time
Today, 05:07
Joined
Dec 20, 2013
Messages
50
hi

trying to get vlookup and sum but unsucessful yet. help will be appreciated.

for example

id text vlookupresult id2 value
1 aa 15 1 3
2 bb 7 1 8
3 cc 4 1 4
4 dd 7 2 7
3 4
4 7

Thank you in advance.
Regards
Muaz
 

Ranman256

Well-known member
Local time
Today, 08:07
Joined
Apr 9, 2015
Messages
4,339
vlookup returns a value.
If you want that value to be a sum, then sum must be in the matrix.

If the matrix shows col(3) as the result of the Vlookup,
then you only need sum(col3) for the sum. Right?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:07
Joined
May 7, 2009
Messages
19,175
Usr SumIf()
 

Users who are viewing this thread

Top Bottom