I need an excel formula

Posted on 2011-03-01
Last Modified: 2012-06-27
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.


I need it to include "Closed" and "Complete - Successful"
Question by:wrt1mea
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

LVL 58

Expert Comment

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

Author Closing Comment

ID: 35012910
Works great!

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".

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Ask a Question