Forum Discussion
Only including cells containing certain words / numbers in formula?
I have a new job as a sepsis specialist nurse. At the end of the month, using all the data inputted throughout the month, I have to work out how many high risk patients received IV antibiotics withi...
Create this formula:
=COUNTIFS(I2:I1000, "HIGH", Q2:Q1000, "<="&TIME(1, 0, 0))/COUNTIFS(I2:I1000, "HIGH")
If your data extend below row 1000, adjust the ranges accordingly.
Format the cell with the formula as a percentage.
This is great, thank you, works perfectly!
