Lesson 2 – B : work on table (sum )
The figure below shows us 3
salespersons and the no. Of units sold during the week
We want to know the sum of
sold units per person and per day
To get the total of every salesperson
we will go to cell B9 and we need to sum the sold units in cells from B3 to B8
, so it will be as we said before we have to start with equal sign :
=b3+b4+B5+b6+b7+b8
Or
=sum(b3+b4+B5+b6+b7+b8)
Or this is the new thing
If you want to sum range of
cells , you can use SUM and define the first cell in the range and the last
cell in the range and separate them with ‘:’ for example , we want to sum cells
from b3 to b8 so it will be :
=sum(b3:b8)
after you finish click enter to get the result
And we also will get the same result
So we calculated the sum of
first salesperson Tamer , then how can we do the same function for the other
salespersons without redundancy?
The easiest way is to click
and drag the function by the pointer which will appear when you put the mouse
on the bottom right corner of the cell it is
look like a black cross
Comments
Post a Comment