Formula Help

[Jason Shukovsky]

I want to callculate the total amount of hours of 5 only if the cell
prior to each of the five cells contains a one.

Im using this for payroll.
I pay people by the shift but want to calculate there total number of
hours worked.

 

[dlw]

if the A column has the ones, and the B column has the numbers you want to sum:

=SUMIF(A1:A5,1,B1:B5)