Formula Help

  • Thread starter Thread starter Jason Shukovsky
  • Start date Start date
J

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.
 
if the A column has the ones, and the B column has the numbers you want to sum:

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