One way:
=SUMPRODUCT(SUBSTITUTE(SUBSTITUTE(A1:A5,"Completel y
Inadequate",""),"Completely Adequate","")+0)
Adapt the range to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"David Aukerman" wrote:
I have a range of cells with these (and only these) possible values:

"1 Completely Inadequate"
"2"
"3"
"4"
"5 Completely Adequate"

Is there a way for me to SUM the values of these cells, including the 1s and
5s which include extra text? Thanks!