somydelafomy
New Member
- Joined
- Jun 4, 2014
- Messages
- 7
Hello,
I am building a sheet to keep track of various standards' revisions of the our industry. I would like to display the quantity of outdated standards in a welcome page but I can't get my formulas to work. I want the formula to count a cell if it matches the adjacent cell. I have tried variation of the following formula but I can't get it to work: =COUNTIF(Revision!A2:A45, "="Revision!B2:B45)
The result that it should return is 7.
<tbody>
</tbody>
Thanks in advance for your assistance. Sorry if If made some English mistakes as it's not my native language and I'm still learning.
I am building a sheet to keep track of various standards' revisions of the our industry. I would like to display the quantity of outdated standards in a welcome page but I can't get my formulas to work. I want the formula to count a cell if it matches the adjacent cell. I have tried variation of the following formula but I can't get it to work: =COUNTIF(Revision!A2:A45, "="Revision!B2:B45)
The result that it should return is 7.
Owned Revision | Revision Available |
9 | 9 |
1(2013) | 1(2013) |
12 | 14 |
10 | 12 |
9 | 13 |
9 | 12 |
11 | 13 |
11B | 13D |
8 | 14 |
11 | 11 |
<tbody>
</tbody>
Thanks in advance for your assistance. Sorry if If made some English mistakes as it's not my native language and I'm still learning.