Hello friends,
today we will discuss about SUM function in Excel. Here in this below given example in column A has some item and column B has its value and in cell B9 has the sum of all these items located in column A.
Simply I put the formula =SUM(B1:B7) and suddenly the sum appears in the cell B9, so this is the simple formula for doing sum quickly.
today we will discuss about SUM function in Excel. Here in this below given example in column A has some item and column B has its value and in cell B9 has the sum of all these items located in column A.
Simply I put the formula =SUM(B1:B7) and suddenly the sum appears in the cell B9, so this is the simple formula for doing sum quickly.
we can count the cell value manually but these are only seven items and it is easy to count the cell values manually but where the data is more than 100s of rows then it will be difficulty to count the sum of the commodity, so in this case we use this formula to simply doing sum of all the items value quickly.
Keep learning Excel.
Narendra
No comments:
Post a Comment