Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculations

Full and Partial Mayo Scores: Adding Ulcerative Colitis Subscores

Add pre-scored 0–3 components for the full Mayo score and its three-component partial version, and see why the partial score cannot establish endoscopic findings.

Two related measures with different inputs

The Mayo score for ulcerative colitis sums four components: stool frequency compared with the person’s usual pattern, rectal bleeding, endoscopic appearance and a clinician’s global assessment. Each is scored from 0 to 3, for a full total of 0–12. The three-component partial Mayo score omits the endoscopic component, giving a total of 0–9.

A partial score can be calculated without a current endoscopic subscore, but it cannot show mucosal appearance or establish endoscopic remission. The British Society of Gastroenterology’s 2025 guideline describes multimodal monitoring rather than relying on a clinical index alone. Use of these measures and interpretation of response or remission depend on clinical context and the specific study or protocol.

These examples add already assessed item scores; they do not diagnose disease, predict an individual outcome or prescribe treatment.

Full Mayo score (four items)

Enter an integer from 0 to 3 for each item in B2:B5. A missing item is not a zero. With 2 in each cell the full score is 8.

=IF(OR(COUNT(B2:B5)<>4,AND(B2<>0,B2<>1,B2<>2,B2<>3),AND(B3<>0,B3<>1,B3<>2,B3<>3),AND(B4<>0,B4<>1,B4<>2,B4<>3),AND(B5<>0,B5<>1,B5<>2,B5<>3)),"Invalid or missing Mayo subscore",SUM(B2:B5))

Partial Mayo score (three non-endoscopic items)

This formula uses B2, B3 and B5 only; B4 can be empty when endoscopy is unavailable. Each of the three used cells must contain an integer from 0 to 3. The same values of 2, 2 and 2 produce a partial score of 6.

=IF(OR(COUNT(B2:B3,B5)<>3,AND(B2<>0,B2<>1,B2<>2,B2<>3),AND(B3<>0,B3<>1,B3<>2,B3<>3),AND(B5<>0,B5<>1,B5<>2,B5<>3)),"Invalid or missing Mayo subscore",B2+B3+B5)

Try the example

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

Further reading