Solved

# I need an excel formula

Posted on 2011-03-01
827 Views
OK guys, last one for the day...

I am needing a formula that will look at two criteria instead of 1. I got this one earlier from Barryhoudini, but I need to add another criteria to it that I am not getting to work.

=(C6="Closed")+0

I need it to include "Closed" and "Complete - Successful"
0
Question by:wrt1mea
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions

LVL 81

Accepted Solution

zorvek (Kevin Jones) earned 250 total points
ID: 35012496
=(OR(C6="Closed",C6="Complete - Successful"))+0

Kevin
0

LVL 58

Expert Comment

ID: 35012510
=(C6="Closed")+(C6="Complete - Successful")
0

LVL 1

Author Closing Comment

ID: 35012910
Works great!
0

LVL 1

Expert Comment

ID: 35012970
If you want either "Closed" or "Complete-Successful", then use zorvek's solution:

=(OR(C6="Closed",C6="Complete - Successful"))+0

The suggestion provided by cyberwiki will work if you want to require C6 to contain both "Closed" and "Complete-Successful".
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Title # Comments Views Activity
Lookup - Vlookup 9 43
Formula fix for vlookup and iserror 3 24
Tricky Shapes formula 3 13
Copy entire column 6 22
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabilâ€¦
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

#### 740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.