Search results

Thank you for your explanation. I am so relieved !!!

The workers have different payout amounts . Payout Drywall is the formula I'm trying to use per worker amount. =SUMIF(0.13*I2,D2=("Panther"),0.14*I2,D2=("Isaac"),0.16*I2,D2=("Mano"),0.18*I2,D2=("Fabin"),0.16*I2,D2=("Salvador"))) When I tried to do it like this =sumIF(D2, "Panther",[0.13*I2])...

https://docs.google.com/spreadsheets/d/1cpiTxvBFzAUk-L43HyICczc8RWoaPPqunUMYlesQkkg/edit?usp=sharing

This is crazy. (D2:D10000) I still can't figure out what is wrong now

=sumIF (D2:D1000,"Panther", [0.14*I2]), (D2:D1000,"Issac", [ 0.16*I2]), (D2:D10000,"Mano", [0.18*I2])))))

I'm trying to get this to work =SUMIF(0.13*I2,D2=("Panther"),0.14*I2,D2=("Isaac"),0.16*I2,D2=("Mano"),0.18*I2,D2=("Fabin"),0.16*I2,D2=("Salvador")))