Countif

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

I need to use the 'countif' feature but I do not need it to count ho
many times the specified is typed. I need to count the number that i
beside the specified.
For example, I am counting 'overtime hours' which is 'ot' but with th
number of hours beside it. (ie. ot2 I need it to add the 2 but only i
an ot is infront of it) I also have to count 'straight time' and 'tim
off' the same way
 
Cheryl,

This isn't really counting. It's summing. Use SUMIF(OTColumn, "ot",
HoursColumn). It might look like

=SUMIF(B2:B65000, "ot", C2:C65000)

depending on your columns.
 
Back
Top