askall1000
Board Regular
- Joined
- Jan 3, 2019
- Messages
- 58
- Office Version
- 2016
- Platform
- Windows
Hello, I want to count non blanks and non zeros with sumproduct formula, i can do it with continious range but i want to ignore text column with formula in H3 but it give #VALUE! error. How can i correct it or any better alternatives. Thank you very much in advance. my table as follow: