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

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History