T
thm
I'm trying to create a formula that will look up criteria in one column and
count the result of another column. Here is some data as an example:
Fruit Have in Stock
Orange X
Pear X
Apple
Orange X
Orange
Apple X
I'm trying to create a formula that looks up "Orange" in column A and then
counts the number of "X" in column b to return a results. So my result for
Oranges should be 2 because out of the 3 listed only 2 have an "X" marked
next to it.
count the result of another column. Here is some data as an example:
Fruit Have in Stock
Orange X
Pear X
Apple
Orange X
Orange
Apple X
I'm trying to create a formula that looks up "Orange" in column A and then
counts the number of "X" in column b to return a results. So my result for
Oranges should be 2 because out of the 3 listed only 2 have an "X" marked
next to it.