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

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

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

Array enter this formula: =SUM((A1:A12="A")*(B1:B12=3))

by using Ctrl-Shift-Enter

perfect thank you!

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

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.

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History