Countif with multiple conditions

December 8, 2011 at 02:13:55
Specs: Windows 7
Hi,
My table has space for users to input several (up to 3) strategies along the same row (each user gets one row), although they might only have used 1 or 2 strategies. I need to count where users have tested ALL their strategies, regardless of the number they have.

So I need a formula that will count lines where only "Yes" appears in 3 "tested" columns on the row, but not discount the blank cells where only one strategy has been selected.

Many thanks,

Thomas


See More: Countif with multiple conditions

Report •


#1
December 8, 2011 at 04:39:39
What version of Excel are you running? Excel 2007 and higher havw a COUNTIFS function that might work for you.

However, since we can't see your spreadsheet from where we're sitting, it might help if you posted an example of your data along with the expected results based on that data.

Before you post your example, please click on the following line and read the instructions on how to post data in this forum.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
December 8, 2011 at 07:54:02
Thanks for your response,
I am using Excel 2010.
Imagine a table with column headings as below:
Name, Level, Plan 1, Plan 1 Tested, Plan 2, Plan 2 tested, Plan 3, Plan 3 tested

Level is a number, "tested" columns are a "yes" or "no"- everything else free text.

I can use a SUMPRODUCT to look along the tested columns to count all "yes" by Level, but I can't get the count to happen where Users do not have 3 plans. If a user has 1 or 2 plans, but the plans they do have are tested, I want to count that.

Cheers,

Thomas


Report •

#3
December 8, 2011 at 10:11:00
Sorry, but I'm still not clear where your problem lies.

Posting just the Column headings and telling us that you are using SUMPRODUCT isn't enough for us to work with.

Keep in mind that you know exactly what you have and exactly what you are trying to do. In otherwords, you have internalized your requirements and can visualize what you are looking for.

We, however, don't have the benefit of that insight, nor do we have the ability to see your spreadsheet, so you need to be specific and use actual examples if you want us to help.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question