COUNTIF and cell matching the countif

[beachsideaccounting]

I am trying to make a formula and I have part of it down. Here is the working half. The time sheet has drop down lists with choices of 12 HR REG, 24 HR REG, etc. These are 12&24 hour shifts. The cell next to 12 HR REG (not always in the same cell) is the total number of hours (not always the same number). I would like to add to the COUNTIF the hour number. No two cells are ever the same. This is for a weighted average calculation on a paycheck.

=COUNTIF('Time Sheet'!B24:H30, "12 HR REG")

 

[gehusi]

You have a string of decimals after the 12.56, which is why its calculating to 502.48. The value in B16 is 609.26/48.5 = 12.5620618.....

Expand the number of decimals on B16's formatting and you'll see it.

Make sense?

 

[beachsideaccounting]

Yes sir, is there a way to block that from happening? I have scoured the Excel 2010 In Depth book and I can't find anything. It has been 15 years since I touched excel.

 

[gehusi]

Wrap your existing formula in B16 with the round function:

=ROUND(*existing formula*,2)

 

[beachsideaccounting]

What is wrong with me? Got it THANK YOU * A MILLION

 

[gehusi]

You are welcome.