G
Guest
I have two adjacent columns, one with cell values of either 20 or 40, the
other with values of "H", "R" or "D"
What I want to do is go through and compare the cells of each column, like
B1 to C1, B2 to C2 etc.
I want to count how often B# is 40 and C# is "R", B# is 40 and C# is "H" etc.
I've used countless COUNTIF statements and IF statements and COUNT
statements... I just can't seem to get a number above 1!
other with values of "H", "R" or "D"
What I want to do is go through and compare the cells of each column, like
B1 to C1, B2 to C2 etc.
I want to count how often B# is 40 and C# is "R", B# is 40 and C# is "H" etc.
I've used countless COUNTIF statements and IF statements and COUNT
statements... I just can't seem to get a number above 1!