I have an excel(2002) worksheet with 5 columns and 100 rows with random cells values. I would like to count how many cells in the worksheet have values like A1 %26amp; A2. For example, A1=3, A2=11, if B9=3 and B10=11 then count value is 2. Thanks for help.How to count two cells with different value in a worksheet?
Use the ';countif()'; function.
No comments:
Post a Comment