tkaplan
08-14-2008, 11:50 AM
hi all,
need some help. i used to know how to do this but for some reason i cant remember now.....
need a formula:
in col A rows 1 thru 500 have values = can be "a", "b", or "c"
in col b rows 1 thru 500 have values = can be "x" or "y"
need formula to do the following:
count how many rows there are that have "a" in col A, and "x" in col b
count how many rows there are that have "a" in col A, and "y" in col b
count how many rows there are that have "b" in col A, and "x" in col b
etc
help would b greatly appreciated!!!
need some help. i used to know how to do this but for some reason i cant remember now.....
need a formula:
in col A rows 1 thru 500 have values = can be "a", "b", or "c"
in col b rows 1 thru 500 have values = can be "x" or "y"
need formula to do the following:
count how many rows there are that have "a" in col A, and "x" in col b
count how many rows there are that have "a" in col A, and "y" in col b
count how many rows there are that have "b" in col A, and "x" in col b
etc
help would b greatly appreciated!!!