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
Bookmarks