Hi,

I was wanting to know if there was a formula in excel that can achieve the following:

I have one column of random numbers from 1 to 10 and a corresponding column with either a 0 or 1. i.e.

Column A Column B
2 0
5 1
9 1
7 0
9 0
6 1
5 1

What I want to do is to search column A for numbers >5 and then sum the corresponding values in column B. So for this example I want it to select: 9, 7, 9, 6, and then sum their corresponding column B values (1+0+0+1=2).

Hopefully I've explained it clearly enough, if not let me know and I'll try again.

Thanks