ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 733
- Office Version
- 2021
- 2019
- 2016
- 2010
- 2007
- Platform
- Windows
Hello - Having some trouble using a formula to count only cells with data. Issue starts when I use a formula and define the output as "" my formula to count actually takes in account those cells see below for my example
Book2 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | COUNT ONLY BLANKS | 11 | |||
2 | DATA | ||||
3 | 1 | ||||
4 | |||||
5 | 1 | ||||
6 | |||||
7 | 1 | ||||
8 | |||||
9 | 3 | ||||
10 | |||||
11 | 4 | ||||
12 | |||||
13 | 4 | ||||
Sheet34 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | B1 | =COUNTIFS(C3:C1048576,"<>0",C3:C1048576,"<>") |
C4,C12,C10,C8,C6 | C4 | =IFERROR(IF(B4="","",""),"") |