dknowles2004
Board Regular
- Joined
- Nov 15, 2004
- Messages
- 79
Hi
I want to count a range of values in Excel (not VBA) so that:
1. If value = 0 then disregard
2. If value = any other value then count count 1 for each instance
For example,
A1 = 0
A2 = 0
A3 = NISS
A4 = FDIA
Count value is therefore 2.
I want to count a range of values in Excel (not VBA) so that:
1. If value = 0 then disregard
2. If value = any other value then count count 1 for each instance
For example,
A1 = 0
A2 = 0
A3 = NISS
A4 = FDIA
Count value is therefore 2.