Smokeyham
Board Regular
- Joined
- Feb 1, 2006
- Messages
- 120
- Office Version
- 365
- Platform
- Windows
I thought this would be simple, but I seem to be missing something.
I want to count the number times the value in the cell in column R matches the same value of a cell in the same row in column A.
For instance
A1 = R1
A5 = R5
A93 = R93
Then the total will be three.
I've been trying to use the CountIf function - but is there another way to do this?
Thanks.....
I want to count the number times the value in the cell in column R matches the same value of a cell in the same row in column A.
For instance
A1 = R1
A5 = R5
A93 = R93
Then the total will be three.
I've been trying to use the CountIf function - but is there another way to do this?
Thanks.....