Ravi Sir's Cards › Excel
Blood Pressure Log in Excel (card 2 of 2)
Revision card 2 for Blood Pressure Log in Excel: Morning systolic average: =AVERAGEIFS(C7:C18,B7:B18,"Morning") gives 130.8; Evening systolic average: =AVERAGEIFS(C7:C18,B7:B18,"Evening") gives 123.0. Includes an example data table.
Read card text
What this card says
2 for Blood Pressure Log in Excel: Morning systolic average: =AVERAGEIFS(C7:C18,B7:B18,"Morning") gives 130.8
Evening systolic average: =AVERAGEIFS(C7:C18,B7:B18,"Evening") gives 123.0. Includes an
Example
data table
Learn this in the lesson: Blood Pressure Log in Excel: Morning and Evening Averages and High Readings Flagged