How to sum up a column when another column has ceratin text?

[kjicha]

Hello, I have a spreadsheet, that in Column A = priority (so a 1, 2, etc..) Column B is Project name, C is Role Name, D is Date, E is scheduled Hours and F is Actual Hours.

What I am trying to do is this:

If column B has 50 rows of the same project name, and there could be 40 role names the same for the project name, I need the actual hours summed up to date.

I need to put this in VB Code within Excel to complete this process.

I hope this makes sense, please help and thank you for your time.

 

[Rijnsent]

Hi Kjicha,
have you had a look at the SUMIFS formula? That formula can do what you describe, no need for VBA. If that is not what you need, how far did you get creating the VBA function?
Kind regards,
Koen