mortgageman
Well-known Member
- Joined
- Jun 30, 2005
- Messages
- 2,015
I comfused and confused!
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?
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?