Thread: Extracting Data using Vlookup and using Sum on the result

Dear All,

I am facing issue while using vlookup and at the same time adding the results of that.

First, I am using vlookup for total count for every individual and then adding them up by using Sum for every individual hours, it is taking hell lot of time. Kindly advice me for any formula which I can use once and my work get done. Uploading file for better understanding.
Like: A is having 4 hours of training in his account in jan and feDummy E-Learning.xlsxb

Simultaneously, I want to see the result once I select any employee, I can see their attended training.

Regards,
Kunal Kumar

Hi,

maybe in G5 and down

=sumif(b:b,b5,f:f)

Regards