Need help either VLOOKUP or any other function.....

[fahadmohsin]

Hi,

This is my first post so I am not sure how this works but I am posting this anyways.

I have a huge file approx. 50K rows and 14 columns. File basically contains data of employees which are approx. 2,500. In every month deductions are made from employees salary. I want to SUM all the deductions made by employees. Every employee has a unique Employee Code e.g. 5132, but the problem is that the deductions are monthly e.g. Jan, Feb, March so I can't use VLOOKUP function as it only selects 1st value.

Please find below a rough idea that how the data is

Date Employee Code Deductions
31-March 5132 500
31-March 5133 480
30-April 5132 510
30-April 5133 500

I have tried my best to explain the problem but if further clarification I can attach the excel file.

Can some one help me on this.

Thanks

[FDibbins]

Hi, welcome to the forum

Sounds to me that you need to use the SUMIF() function for this....=SUMIF(criteria-range, criteria, sum-range)

Give it a go, and if you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[JohnTopley]

Try

=SUMIFS($C:$C,$A:$A,">=01/03/2016",$A:$A,"<=31/03/2016")

will SUM all empoyess for March

=SUMIFS($C:$C,$B:$B,"5132",$A:$A,">=01/03/2016",$A:$A,"<=30/04/2016")

will SUM March and April for Employee ID 5132

[fahadmohsin]

Thanks this really helped me alot.

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.