I have two column lists (two values in first column and one value in the other)
e.g. Column A has the following values: A B C B B A C
Column B has the following values: Yes
I need a formula to count how many A's & B's there are if column B is = Yes
Suppose sample data is like this (row 1 has headings H1 and H2)
Try this formula in an empty cell
you will get 3
Thanks to venkat1926
for this tip on the forum.
Published by aakai1056
Latest update on April 2, 2010 at 09:11 AM by aakai1056.