0:00
hello everyone and welcome in this video
0:02
we'll explore the various ways to sum
0:04
values in Excel including ranges name
0:07
data non-contiguous cells and values
0:09
from other sheets Excel allows you to
0:11
perform mathematical calculations like
0:13
addition subtraction and division using
0:16
simple operators like plus and minus for
0:18
example you can manually add numbers by
0:20
entering an equal sign in a cell and
0:22
Performing the calculation directly but
0:24
Excel offers a more efficient way to sum
0:27
ranges of values using the sum function
0:29
the sum function is one of the most
0:30
commonly used functions in Excel
0:32
designed specifically for summing ranges
0:34
of numbers to sum a range of cells
0:37
simply select the cells as shown on the
0:38
screen here we're summing all the values
0:41
from cells B2 to B13 the sum function
0:44
can handle up to 255 arguments which
0:47
means you can sum a large number of
0:48
cells at once as you see on the screen
0:51
I've entered several cells individually
0:53
separated by commas you can enter up to
0:55
255 arguments this way now if you want
0:58
to some non-contiguous range
1:00
you can easily do that by separating the
1:02
ranges with commas as shown on the
1:04
screen Excel will sum the values from
1:06
both ranges giving you the total
1:13
sum next let's talk about named ranges
1:16
named ranges allow you to assign a name
1:18
to a group of cells making your formulas
1:21
more readable and easier to manage let's
1:23
select the range B2 to B13 then hold
1:26
down the control key and select the
1:30
go to the name box and enter income as
1:32
the name for these two ranges now
1:35
instead of writing out each range
1:36
separately in your Su function you can
1:38
simply use the name income and Excel
1:40
will sum the values from both of those
1:42
non-contiguous ranges this makes your
1:44
formulas cleaner and easier to
1:49
understand here's another handy trick if
1:51
you have a long list of data that
1:53
continues to grow and you're unsure
1:54
where the last cell will be you can sum
1:56
all the values in an entire column by
1:58
referencing the column itself twice for
2:00
example to sum all the numbers in column
2:03
A use the formula as shown on the screen
2:05
this will automatically add every cell
2:07
in column A regardless of how long the
2:13
becomes sometimes your data might be on
2:16
another sheet no problem you can easily
2:18
sum values from a different sheet by
2:20
referencing the sheet name before the
2:22
cell range as shown on the screen this
2:24
approach will pull data from sheet two
2:26
and calculate the total for you
2:34
now what if you want to mix things up
2:36
you can some different data types all at
2:38
once for example you can sum specific
2:41
numbers cells and ranges together Excel
2:44
is smart enough to sum numbers even if
2:46
they're stored as text as long as they
2:48
look like numbers Excel can even some
2:50
logical values true is treated as one
2:53
and false is zero so if I include true
2:56
and false in my formula true adds one to
2:58
the total and false adds n nothing
3:00
that's it for today's tutorial on the
3:02
sum function from summing ranges and
3:04
name data to using logical values array
3:07
constants and even embedding functions
3:09
the sum function is truly versatile I
3:11
hope this video helped you unlock its
3:13
full potential don't forget to like
3:15
comment and subscribe for more Excel
3:17
tips thanks for watching and I'll see
3:19
you in the next video
