I have columns like this:
A
1 B
3 2
1 1 2 1
1 .5 2 .6 1
I need to build a function to pull the data from the first column based on what is in the second column.
If data from column B = 1 then pull data from row A and count it.
I want my return to be the total instances where Row B = 1 and row A <= 1.1.
The return for this instance should be 2.
Thanks
A
1 B
3 2
1 1 2 1
1 .5 2 .6 1
I need to build a function to pull the data from the first column based on what is in the second column.
If data from column B = 1 then pull data from row A and count it.
I want my return to be the total instances where Row B = 1 and row A <= 1.1.
The return for this instance should be 2.
Thanks