On 2002-06-06 05:00, Aladin Akyurek wrote:
=SUM(TRUE,FALSE,TRUE)
=2
Ian,
When this set of logical values are in a range, say, A1:A3,
=SUM(A1:A3)
fails. The Help file states:
SUM(number1,number2, ...)
Number1, number2, ... are 1 to 30 arguments for which you want the total value or sum.
[1] Numbers, logical values, and text representations of numbers that you type directly into the list of arguments are counted. See the first and second examples following.
[2] If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored. See the third example following.
=SUM(TRUE,FALSE,TRUE) by [1] results in 2.
=SUM(A1:A3), where A1=TRUE,A2=FALSE, and A3=TRUE, by [2] results in 0.
Aladin