answersLogoWhite

0

Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:

=SUM(A2:A3)

=SUM(A2,A3)

However, the following will both return 2:

=SUM(A2+A3)

=SUM(TRUE,TRUE)

Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:

=SUM(A2:A3)

=SUM(A2,A3)

However, the following will both return 2:

=SUM(A2+A3)

=SUM(TRUE,TRUE)

Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:

=SUM(A2:A3)

=SUM(A2,A3)

However, the following will both return 2:

=SUM(A2+A3)

=SUM(TRUE,TRUE)

Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:

=SUM(A2:A3)

=SUM(A2,A3)

However, the following will both return 2:

=SUM(A2+A3)

=SUM(TRUE,TRUE)

Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:

=SUM(A2:A3)

=SUM(A2,A3)

However, the following will both return 2:

=SUM(A2+A3)

=SUM(TRUE,TRUE)

Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:

=SUM(A2:A3)

=SUM(A2,A3)

However, the following will both return 2:

=SUM(A2+A3)

=SUM(TRUE,TRUE)

Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:

=SUM(A2:A3)

=SUM(A2,A3)

However, the following will both return 2:

=SUM(A2+A3)

=SUM(TRUE,TRUE)

Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:

=SUM(A2:A3)

=SUM(A2,A3)

However, the following will both return 2:

=SUM(A2+A3)

=SUM(TRUE,TRUE)

Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:

=SUM(A2:A3)

=SUM(A2,A3)

However, the following will both return 2:

=SUM(A2+A3)

=SUM(TRUE,TRUE)

Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:

=SUM(A2:A3)

=SUM(A2,A3)

However, the following will both return 2:

=SUM(A2+A3)

=SUM(TRUE,TRUE)

Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:

=SUM(A2:A3)

=SUM(A2,A3)

However, the following will both return 2:

=SUM(A2+A3)

=SUM(TRUE,TRUE)

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

Is total and sum the same thing in Excel?

SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.


What their values function takes all of the values in each of the specified cells and totals?

If you mean Excel, or similar spreadsheets, you can use the sum() function.


What function takes all of the values in each of the specified cells and totals their values?

If you mean Excel, or similar spreadsheets, you can use the sum() function.


What are the uses of Boolean algebra?

One use of Boolean algebra is to minimize any function or logic gate.


What is the sum of the values stored in cells b4 b5 b6 and b7?

Use following function in any other cell to calculate sum: =sum(b4:b7)


What function do you use to add the value of cells at one go?

SUM - If you want to add the values of cells A1 through A23, use =SUM(A1:A23).


Difference between relational and logical operators?

Logical operators don't Compare values they combine Boolean values and produce a Boolean result. Examples of logical operators are && (and), , (or), ! (not). If you have two Boolean values and you combined them with the && operator the result will be (TRUE) only if both values were (TRUE). Relational operators compare two values and produce a Boolean result. Most of the time we use logical operators to combine the results of two or more comparison expressions that use relational operators.


What is the use and purpose of the function which is average and sum in Ms Excel spreadsheets?

The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:=SUM(A2:A20)The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:=AVERAGE(A2:A20)The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:=SUM(A2:A20)The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:=AVERAGE(A2:A20)The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:=SUM(A2:A20)The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:=AVERAGE(A2:A20)The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:=SUM(A2:A20)The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:=AVERAGE(A2:A20)The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:=SUM(A2:A20)The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:=AVERAGE(A2:A20)The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:=SUM(A2:A20)The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:=AVERAGE(A2:A20)The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:=SUM(A2:A20)The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:=AVERAGE(A2:A20)The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:=SUM(A2:A20)The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:=AVERAGE(A2:A20)The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:=SUM(A2:A20)The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:=AVERAGE(A2:A20)The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:=SUM(A2:A20)The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:=AVERAGE(A2:A20)The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:=SUM(A2:A20)The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:=AVERAGE(A2:A20)


How many bytes does an Boolean take in a c program?

There is no boolean in C, we usually use int/short/char to store logical values.


What is the sum function on spreadsheets?

SUM function is use to aggregate in MS Excel Suppose you want to sum values from A1 to A10 in A11, type = SUM(A1:A10)


Can you use Sum Function in school?

If you use Excel in school, then, yes, you can use the SUM function.


What Excel function is used to add numbers in a range of cells?

The syntax is... sum(start:end) - where 'start' is the first cell in the range and 'end' is the last.