Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

Barthel Index: Validating Ten Daily-Activity Scores

Explore the arithmetic of a common 0–100 Barthel Index form, checking each fictional item score individually.

Ten activities and several scoring versions

The Barthel Index, introduced by Mahoney and Barthel, assesses basic activities of daily living and mobility. One common 0–100 form assigns scores in five-point steps, with maximum item scores of 5, 10 or 15. Other Barthel versions use different scales and item definitions; use the scoring instructions for the version being administered.

A higher total indicates more independence in the activities measured, but a score of 100 does not by itself establish that someone can live independently in the community. Discharge and support planning require a broader assessment.

Items in the common 0–100 formAllowed pre-scored values
Bathing and grooming0, 5
Feeding, dressing, bowels, bladder, toilet use, stairs0, 5, 10
Bed/chair transfer and mobility0, 5, 10, 15

Check every score before summing

Enter ten numeric pre-scored values according to the common form described above. The formula checks each individual value and its item-specific maximum, so two invalid values cannot cancel each other out to create an apparently valid total.

This is a fictional arithmetic example; it is not a functional assessment, a discharge recommendation or a substitute for the instrument’s criteria.

=IF(COUNT(B2:B11)<>10,"Enter all ten numeric scores",IF(OR(MIN(B2:B11)<0,B2>10,MAX(B3:B4)>5,MAX(B5:B8)>10,MAX(B9:B10)>15,B11>10,MOD(B2,5)<>0,MOD(B3,5)<>0,MOD(B4,5)<>0,MOD(B5,5)<>0,MOD(B6,5)<>0,MOD(B7,5)<>0,MOD(B8,5)<>0,MOD(B9,5)<>0,MOD(B10,5)<>0,MOD(B11,5)<>0),"Check each item against its allowed values",SUM(B2:B11)))

Try the example

Use the original values or change them to test your understanding.

Further reading