Miscounting in column T

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,342
No it doesn't.

You have the value 151 in K3, that plus a non zero value in E3 counts as 2.
Excel is correct.

Column K has data that you haven't displayed correctly.
Change the colour column K's text to red and you'll see there are non zero values in that column.
 
Last edited:

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,340
Office Version
2019, 2016, 2013
Platform
Windows
will fudge with =COUNTIF(E3:Q3,">0")-1
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,456
or =SUMPRODUCT(--(F3:Q3>0))

with data like this:

F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
3
0
0
0
0
0
151
0
0
0
0
0
0
294
294
1
4
0
146
148
149
0
151
0
0
0
0
0
0
743
743
4
5
0
0
0
0
0
151
0
0
0
0
0
0
296
296
1
6
0
0
0
0
0
151
0
0
0
0
0
0
151
151
1
7
0
0
0
0
0
151
0
0
0
0
0
0
151
151
1
8
0
0
0
0
0
151
0
0
0
0
0
0
151
151
1
9
0
147
149
0
149
151
0
0
0
0
0
0
744
744
4
10
0
148
0
0
0
151
0
0
0
0
0
0
441
441
2
11
0
0
0
0
0
151
0
0
0
0
0
0
295
295
1
12
0
149
0
0
0
151
0
0
0
0
0
0
446
446
2
13
0
0
0
0
0
151
0
0
0
0
0
0
151
151
1
14
0
0
0
0
0
151
0
0
0
0
0
0
301
301
1
15
75
150
150
150
150
151
0
0
0
0
0
0
973
898
6
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,100,063
Messages
5,472,237
Members
406,809
Latest member
haf19

This Week's Hot Topics

Top