Healthcare & Clinical
SIRS Criteria: A Historical Four-Part Spreadsheet Example
Count the four historical SIRS criteria in a complete example and understand why the result alone cannot diagnose or exclude sepsis.
Historical criteria and their limits
The 1992 ACCP/SCCM consensus described systemic inflammatory response syndrome (SIRS) using at least two of four criteria. Infection is one possible cause of a systemic inflammatory response, but noninfectious conditions can also produce the criteria.
The Sepsis-3 consensus defines sepsis in terms of life-threatening organ dysfunction caused by a dysregulated response to infection. Two or more SIRS criteria do not by themselves establish sepsis; fewer than two do not exclude it. A count is not a diagnosis, treatment plan or substitute for clinical assessment. Pediatric criteria differ.
The spreadsheet below is a complete-data arithmetic exercise: it requires respiratory rate and PaCO2 as well as WBC and bands for simplicity, although each pair represents alternatives in the historical criteria. Missing measurements must not be treated as normal.
| Historical criterion | Threshold | Points in this example |
|---|---|---|
| Temperature | Above 38°C or below 36°C | 1 if either condition is met |
| Heart rate | Above 90 beats/min | 1 |
| Respiratory | Above 20 breaths/min or arterial PaCO2 below 32 mmHg | At most 1 |
| White blood cells | Above 12 or below 4 × 10⁹/L, or immature bands above 10% | At most 1 |
Count the recorded criteria
Enter all six numerical values in B2:B7, in the units shown. COUNT checks completeness; the second guard rejects negative inputs, nonpositive temperature or PaCO2, and bands above 100%. A zero heart rate or respiratory rate is not treated as an invalid number here, but could represent an emergency and this arithmetic exercise cannot evaluate it. The formula returns a count from 0 to 4, not a sepsis diagnosis.
=IF(COUNT(B2:B7)<>6,"Enter all six numeric inputs",IF(OR(B2<=0,B3<0,B4<0,B5<=0,B6<0,B7<0,B7>100),"Check inputs",IF(OR(B2>38,B2<36),1,0)+IF(B3>90,1,0)+IF(OR(B4>20,B5<32),1,0)+IF(OR(B6>12,B6<4,B7>10),1,0)))Try the example
Use the original values or change them to test your understanding.