Good Morning,
I have a sheet of data sorted by employee, I need to calculate the number of occurences by job id (example 27) and hours (7.5) the formula I have so far is as follows.
=COUNTIFS(Data!H:H,27,Data!F:F,"7.5")
This appears to work fine and counts all the instances that meet this criteria. however.
I use the same formula looking for hours of "9.38" instead and it will not calculate, I can't seem to figure out why?
=COUNTIFS(Data!H:H,27,Data!F:F,"9.38")
The only other thing I would like to be able to do with this formula is count only weekdays.
~AZ
I have a sheet of data sorted by employee, I need to calculate the number of occurences by job id (example 27) and hours (7.5) the formula I have so far is as follows.
=COUNTIFS(Data!H:H,27,Data!F:F,"7.5")
This appears to work fine and counts all the instances that meet this criteria. however.
I use the same formula looking for hours of "9.38" instead and it will not calculate, I can't seem to figure out why?
=COUNTIFS(Data!H:H,27,Data!F:F,"9.38")
The only other thing I would like to be able to do with this formula is count only weekdays.
~AZ