For someone using Excel to keep an ongoing record of their blood pressure in two columns. The first of these is for systolic and the second for diastolic. At the bottom of each of these columns it is easy to determine the high, low and average of these readings. However, another item that is needed to be added is, which of these readings falls within one of 4 categories and then sum the total of such values. Although an if statement would cover the greater, or less than value. How does one then sum these all up keeping in mind the addition of rows? Rows are added each time a reading is taken so the tally is one that is ongoing.
Day Systolic Diastolic
1 x y
2 x1 y1
Desirable = If cells B2 - B~ is less than 10 but greater than 5
Caution = If cells B2 - B~ is less than 20 but greater than 10
Warning = If cells B2 - B~ is less than 30 but greater than 20
Red Alert = If cells B2 - B~ is less than 40 but greater than 30