I have set up a google spreadsheet to determine my monthly payroll per employee.

Column F is hours worked per day, and G is employee name (only one employee per day set up as a drop down selection in each cell of column G).

I used =100*ARRAYFORMULA(SUM(IF($G$7:$G$37=ʺGuptaʺ,$F$7:$F$37,0),0)) for the first employee and =125*ARRAYFORMULA(SUM(IF($G$7:$G$37=ʺPatelʺ,$F$7:$F$37,0),0)) for the second employee and so on.

The formula works as expected for the first employee but does not get calculated for each subsequent employee.

What am I doing wrong?