Hi out there,

I am wishing to add a group of data which is in a column but the data is
TEXT ONLY.

i.e I have a column which contains the text YES and NO. I wish to add all
the fields containing YES without having to create another column which makes
the text into a number using say an IF formula then adding that column.

Is that possible or do I have to change the text to a number using
validation or IF formula?