Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculations

Katz ADL: Add Six Assessed Independence Items

Sum six already-assessed Katz activities of daily living as numeric 0/1 inputs, while recognizing item-specific criteria and limits of the score.

A six-item view of basic daily activities

A common modified Katz activities of daily living (ADL) scale records six items: bathing, dressing, toileting, transferring, continence and feeding. Each item is assigned 1 when its specified independence criterion is met, otherwise 0. Adding the six values produces a total from 0 to 6; higher totals indicate that the independence criteria were met in more of the assessed activities.

The criteria are item-specific and should be assessed using the applicable scale version. For example, the modified scale cited below can count bathing as independent when help is needed for only one body part; it also allows some aids or limited help in other specified circumstances. Therefore, a blanket rule that any assistance always scores zero would be wrong.

This example adds scores already assigned by an assessor. It does not determine care placement, supervision needs or a treatment plan. Individual abilities and support needs can differ within the same total, and recovery does not follow a guaranteed sequence.

Fictional item pointsTotalWhat the sum says
0, 0, 1, 1, 1, 14Four of six specified criteria met
1, 1, 1, 1, 1, 16All six specified criteria met
0, 0, 0, 0, 0, 00None of the six specified criteria met

Sum six numeric item scores

Enter six assessed 0/1 scores in B2:B7. Missing information is not the same as dependence and is rejected instead of silently scored zero.

=IF(COUNT(B2:B7)<>6,"Missing or nonnumeric input",IF(OR(AND(B2<>0,B2<>1),AND(B3<>0,B3<>1),AND(B4<>0,B4<>1),AND(B5<>0,B5<>1),AND(B6<>0,B6<>1),AND(B7<>0,B7<>1)),"Use numeric 0 or 1",SUM(B2:B7)))

Try the example

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

Further reading