Countif Statements

Microsoft Excel 2003 (full)
August 20, 2009 at 12:43:49
Specs: Windows Vista
Here is my data
Column 1 Column 2
A 3
A 3
A 2
A 2
B 1
B 3
B 3
B 3
C 1
C 3
C 2
C 3


I 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

Report •


#1
August 20, 2009 at 15:41:22
Combine Column A & B into Column C
and do your =COUNTIF() on column C

MIKE

http://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.

MIKE

http://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 •


Ask Question