Menu

Excel forumlas [Closed]

Report

Shelly - Jun 1, 2010 at 05:16 PM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- Jun 1, 2010 at 05:23 PM

Hello,

I have a column that contains "yes" or "no". I need to total the "yes" in each column. What is the formula to do this?

Thanks

Related:

Excel forumlas
Excel Forumla help (IF formula) ✓ - Forum - Excel
Budgeting forumla in Excel ✓ - Forum - Excel
How to change date format in excel to dd/mm/yyyy - How-To - Excel
Transfer data from one excel worksheet to another automatically - How-To - Excel
Excel @ in formula ✓ - Forum - Excel

2 replies

Answer 1 / 2

seeBlack
Jun 1, 2010 at 05:23 PM

=COUNTIF(E8:E14,"yes")

Answer 2 / 2

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

767
Jun 1, 2010 at 05:23 PM

use a countif function

Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Recommended

DON'T MISS