Count Cells Based On Conditions

September 26, 2012 at 11:31:02
Specs: Windows 7
In excell 2010 I have to COUNT differents conditions in column A and check in column B, 3 conditions (Cancel for Conversion,Company Decline and Cancel for non Pay) if in column B is one of these conditions is TRUE, you should not count it, but if you do not find any of these three conditions in colum B should count. Please i really need help with this. Thanks
A B

Review Issued
Review Cancel for non Pay
Review Cancel for Conversion
Review Company Decline
Prospect Issued
Prospect Issued
Prospect Company Decline
Prospect Cancel for Conversion
Referral Issued
Referral Issued
Referral Cancel for non Pay
Referral Issued



I NEED THIS RESULTS

Review 1
Prospect 2
Referral 3

See More: Count Cells Based On Conditions

Report •

#1
September 26, 2012 at 12:04:13
When posting in a Help forum, please try to use a thread title (subject line) that is relevant to the contents of your post.

If everyone used a generic thread title such as yours (e.g. "I need help!") then we wouldn't be able to tell one post from another and the archives of the forum would be useless.

Look at some of the other thread titles in this forum to see what I mean.

I have edited the thread title of your post to be relevant to it's contents.

In addition, please click on the blue line at the end of this post and read the instructions on how to post example data in this forum. After you have read the instructions, please repost your data so that we can see how it should be laid out.

DerbyDad03
Office Forum Moderator

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


Report •

#2
September 26, 2012 at 12:17:15
Thanks DerbyDad03, this is the first time I ask for hep in a Forum. I appreciate your understanding. Thanks Again

Report •

#3
September 26, 2012 at 12:29:12
Based on your example data, why not just count the cells where Column B is "Issued"?

Wouldn't it be easier to check one condition instead of 3?

Starting with this table, drag the formula in B14 down 2 cells.

        A                         B
1   Review                Issued 
2   Review                Cancel for non Pay 
3   Review                Cancel for Conversion 
4   Review                Company Decline 
5   Prospect              Issued 
6   Prospect              Issued 
7   Prospect              Company Decline 
8   Prospect              Cancel for Conversion 
9   Referral              Issued 
10  Referral              Issued 
11  Referral              Cancel for non Pay 
12  Referral              Issued
13
14  Review                =COUNTIFS($A$1:$A$12,A14,$B$1:$B$12,$B$1)
15  Prospect
16  Referral

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


Report •

Related Solutions

#4
September 26, 2012 at 12:51:21
Sorry I not show you all the data the colum B have this 5 conditions:

Issued
Pending
Cancel for Conversion
Cancel for non Pay
Company Decline


Report •

#5
September 26, 2012 at 12:57:12
I using this formula in A Summary Sheet for: =COUNTIF('Q1'!A4:A99,"Review") and I need add in this formula the conditions for no counth this ones: (Cancel for Conversion,Company Decline and Cancel for non Pay). I have only 2 conditions for count (Issued and Pending ), I sure you right maybe is more easy check 2 condition that than 3.

Thanks


Report •

#6
September 26, 2012 at 13:22:43
To check for all three conditions, try this:

=COUNTIFS(A1:A5,"=Review",B1:B5,"<>Cancel for non Pay",B1:B5,"<>Cancel for Conversion",B1:B5,"<>Company Decline")

If you want to use cell references instead of the hard coded strings, you need to use the concatenation operator:

e.g. if Review was in G1, you would use this:

=COUNTIFS(A1:A5,"=" & G1, etc.

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


Report •

Ask Question