Carla carla
New Member
- Joined
- Oct 29, 2022
- Messages
- 47
- Office Version
- 365
- Platform
- Windows
Hello,
I've manage to write a countif formula but it counts n/a too..
How can i countif ignoring n/a?
this is the formula
=COUNTIFS('NGRT DATA'!C:C,"year 3 b",'NGRT DATA'!Z:Z,"<>")
and this is what i am trying to do.
thanks
I've manage to write a countif formula but it counts n/a too..
How can i countif ignoring n/a?
this is the formula
=COUNTIFS('NGRT DATA'!C:C,"year 3 b",'NGRT DATA'!Z:Z,"<>")
and this is what i am trying to do.
thanks