Time in Range, Below & Above: COUNTIFS with 70–180 mg/dL Bands
This lesson is part of the course
In this lesson
You compute the share of a day's readings in range (70–180 mg/dL), below 70, below 54 and above 180 with COUNTIF and COUNTIFS.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Readings per Day & Data Sufficiency (% of Expected Readings) Locked
- Mean Glucose & Converting mg/dL ↔ mmol/L Locked
- Time in Range, Below & Above: COUNTIFS with 70–180 mg/dL Bands Locked
- Glucose Management Indicator: GMI = 3.31 + 0.02392 × Mean Locked
- Glucose Variability: SD, Coefficient of Variation & a Stability Flag Locked
- Daily Pattern by Hour: AVERAGEIFS & a Line Chart Locked
- Hypoglycaemia Events: Consecutive Readings Below 70 for ≥ 15 Minutes Locked
- Weekly Summary Report: Time in Ranges, Targets, Highlights & a Stacked Chart Locked