derrickjp7
New Member
- Joined
- Jan 30, 2020
- Messages
- 16
- Office Version
- 2019
- Platform
- Windows
Hey Everyone,
I'm trying to use a dynamic range and COUNTIF to count how many "na" are within it. I'm confused why when the first cell in the range C3 is empty, it does not count any "na." But when I put "na" in C3 it counts both. Any suggestions? Take a look at the images for some screen shots. B3 and G3 also contain formulas.
I'm trying to use a dynamic range and COUNTIF to count how many "na" are within it. I'm confused why when the first cell in the range C3 is empty, it does not count any "na." But when I put "na" in C3 it counts both. Any suggestions? Take a look at the images for some screen shots. B3 and G3 also contain formulas.