See attached. I've simplified the individual totals, e.g.:
{IF{REF Impact}= "Critical" 7 {IF{REF Impact}= "High" 5 {IF{REF Impact}= "Med" 3 {IF{REF Impact}= "Low" 1 0}}}}
and created the overall tally:
{IF{=E8}< 3 "NA" {IF{=E8}< 7 "Low" {IF{=E8}< 11 "High" "Critical"}}}

Attached Files

Content Values.docx (20.3 KB, 21 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]