Miscounting in column T

[ollyhughes1982]

Hi. In the linked spreadsheet, please could someone fix the count in column 'T'. It keeps counting one too many.

Thanks in advance.

https://1drv.ms/x/s!AtIvkRgReIvwgRbfii9zm52ozImr

 

[Special-K99]

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.

 

[mole999]

will fudge with =COUNTIF(E3:Q3,">0")-1

 

[sandy666]

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​