ChrisFoster
Active Member
- Joined
- Jun 21, 2019
- Messages
- 251
- Office Version
- 365
- Platform
- Windows
Hi all,
I feel a bit silly here. I have the following simple formula that works, it brings back a value of 25 which is correct.
However, as the data in column A may exceed 100, I am trying the below code but it just brings back a value of 1. What am I doing wrong?
I feel a bit silly here. I have the following simple formula that works, it brings back a value of 25 which is correct.
Excel Formula:
=COUNTA('Exception Breaches'!A2:A100)
However, as the data in column A may exceed 100, I am trying the below code but it just brings back a value of 1. What am I doing wrong?
Excel Formula:
=COUNTA('Exception Breaches'!A2:A)