Formula

B

Bobbybee

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What's Wrong With This Formula? 12
Filtering with SUMIFS 1
Split column contents (de-concantenate) 7
Formula 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Formula help--Vlookup? 8
Concantenate which keeps bold of some parts. 5
Reference Formula Help 1

Top