Countif Statements

Microsoft Excel 2003 (full)
August 20, 2009 at 12:43:49
Specs: Windows Vista
 Here is my dataColumn 1 Column 2A 3A 3A 2 A 2B 1 B 3B 3B 3C 1C 3C 2C 3I am trying to do a statement that would search column 1 for all the "A" values and then return any "3" value off of it. So my results in this case would end up being "2". Any ideas?Thanks,Jared

See More: Countif Statements

#1
August 20, 2009 at 15:41:22
 Combine Column A & B into Column Cand do your =COUNTIF() on column CMIKEhttp://www.skeptic.com/

Report •

#2
August 20, 2009 at 17:33:36
 Thanks I was just hoping there would be an easier way to do it then making an additional 7 or 8 columns in my spreadsheet since there is more data than what I attached. But I guess I have to do it the hard way lol

Report •

#3
August 20, 2009 at 17:49:22
 What does the real data look like, there may be other ways to do what you need.I just showed you a fast and easy way, not the only way.MIKEhttp://www.skeptic.com/

Report •

Related Solutions

#4
August 20, 2009 at 19:50:45
 Array enter this formula:=SUM((A1:A12="A")*(B1:B12=3))by using Ctrl-Shift-Enter

Report •

#5
August 21, 2009 at 04:54:44
 perfect thank you!

Report •

#6
August 21, 2009 at 10:49:25
 Just trying to understand how this works. Why does the * in the formula not multiply the 2 values together? The formula works perfect but just trying to understand it fully.Thanks

Report •

#7
August 21, 2009 at 16:55:34
 re: Why does the * in the formula not multiply the 2 values together?It sort of does, but keep in mind that this is an array formula.Try this:Select the cell with the formula and click on Tools...Formula Auditing...Evaluate Formula.Then click on the Evaluate button and single-step through the formula.See if you can figure out what's happening.

Report •