#### mortgageman

##### Well-known Member

- Joined
- Jun 30, 2005

- Messages
- 2,015

In Cell G47 I have =1=1, which displays as TRUE. In Cell G48 I have =1=2 which displays as FALSE. In cell G49 I have =sum(g47:g48) which results in 1 AS EXPECTED.

Now In cells e39 through e44 I have: 1,2,3,1.1,-1,4

In cells f39 through f44 I have the array formula {=abs(int(e39:e44))} which results in 1,2,3,1,1,4

In cells g39 through g44 I have the array formula {=(f39:f44=1)} which results in TRUE,FALSE,FALSE,TRUE,TRUE,FALSE

In cell g45 I have sum(g39:g44) which results in 0 NOT AS EXPECTED.

Why does the sum of an array of TRUE's and FALSE's sum differently than a non array?