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
 
Have you looked at the sumif function?

It appears to be tailor made for your problem
 
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.
 
You must log in or register to reply here.

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

Excel Need Countifs Formula Help 0
Is this formula even possible? 9
Counting text 2
Countif formula 2
Need help with a timesheet formula 1
Countif/Vlookup 2
Conditional summing when more than one condition must be met 4
Excel Formula - Count Dates from another Sheet 8

Back
Top