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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing text into a formula? 8
Pivot Table Filter Formula 1
Excel formula 5
why is answer rounded up? 1
If Formula 2
time sheet and majority hours 8
Excel Sumproduct 0
Calculating total amount in a Pivot Table 1

Back
Top