I have set up countif formula that calculates the number of vacancies as 1 each for ML, or UPL or LTSL or SL for each week. However I want the actual temporary vacancy figure to be reflective of the actual hours e.g. H15 is .92 hours but my current formula is calculating that as 1. How can I factor the Actual hours rating into my formula. My desired answer for the first week is in K9 (2.85) as opposed to the 3.0 I have.