Adding up bonus in given month for the employee?

[domgilberto]

Hi all!

I have attached the spreadsheet that I am developing with the kind help of the community members from this site! (really appreciative!!)

Screenshot attached shows EXACTLY what I am after

[domgilberto]

Anyone - Sorry to be inpatient, just really need someones help! I hope I have made it clear enough with the screenshot and spreadsheet attached!

[domgilberto]

Hellllooooo ?

[domgilberto]

Come on... Please can someone have a peak?

[Miroslav R.]

Hi,
sorry, but from attached picture, I am not able to solve what do you want to achieve... Be more specific...

Regards

M

[domgilberto]

Hi,
sorry, but from attached picture, I am not able to solve what do you want to achieve... Be more specific...

Regards

M

Thank you for offerint to help

Ok, in "Bonus Owed", if that says "Yes", then that given "Engineer" is owed the monetary value stated in "Potential Bonus" box for the corresponding month stated in "Report Received".

For example, in that particular spreadsheet that I have attached, "Darren Street" is owed £50 from the month of April. This is because he has 1 "Yes" next to "Potential Bonus" and he sent that report in on the month of April. He had sent in one report, but it was not in on time. Therefore he will not get that bonus. So his sum total in the table above will be: £50...

Hope that explains it.

[hemesh]

In B2
copy paste below and hit enter
=SUMPRODUCT(--(TEXT($C$19:$C$27,"MMMM")=B$1)*($A$19:$A$27=$A2)*($I$19:$I$27="Yes")*($H$19:$H$27))

drag down and to right . Adjust the ranges

[Miroslav R.]

Hi,

see attachement:

test (1).xlsx

Regards

M

[hemesh]

for Savings Part copy paste below in B14 then hold control and shift together and then hit enter to make it array formula
=SUMPRODUCT(--(TEXT($C$19:$C$27,"MMMM")=B$1)*(($A$19:$A$27)=TRANSPOSE($A$2:$A$9))*($I$19:$I$27="NO")*($H$19:$H$27))

Drag to right

[domgilberto]

Superb! Thank you guys very much!

So kind of you to help! :D!