vlookup with sum (1 Viewer)

Muaz

Registered User.
Local time
Today, 02:45
Joined
Dec 20, 2013
Messages
50
hi

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

Example attached


Thank you in advance.
Regards
Muaz
:banghead:
 

Attachments

  • example.xlsx
    8.2 KB · Views: 105
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:45
Joined
May 7, 2009
Messages
19,169
Use sumif() function
=SumIf($g$2:$g$12,b2,$h$2:$h$12)
 

Muaz

Registered User.
Local time
Today, 02:45
Joined
Dec 20, 2013
Messages
50
That's great. Thank you very much. Resolved.

Regards
Muaz
 

Users who are viewing this thread

Top Bottom