In our previous worksheet we have learn, how to do summation. Better we discus with example. Let’s think like this way- we went to by that 5 products and total cost comes182 dollar. We paid to the cashier 200 dollar. How much should we get back? Simple right? 18 dollar. That means total cost minus (-) total cash given to the cashier.
How we can do it in excel!
• Do the summation for all item value, suppose the value comes in C7
• Put paid amount in cell C8
• Write formula in C9 likes “=(C8-C7)" then press Enter
• Result will come 18
Repeat the same thing 2/3 times for more practices.
Suppose we have done lots of shopping, Saturday we have brought something, Sunday something and Monday also something. This is our weekly shopping and now we wants to know how much we spend in a week and how much in average,
1st we will find out the total weekly shopping amount-
• Put your cursor in a empty cell and write =SUM(C10,H10,M10) then press Enter. You will see the amount 220
Now we can find out easily, how much we spend in average-
• Simply remove the word “SUM” and put “AVERAGE”. You will see the value 73.3333
Check the tutorial from attached file
In the tutorial you might have seen 2 comments. Wanna learn how to do that? Just right click on the value; then select "Insert Comment. You can show or hide the comment any time followed by the same way. See the below image to make more understanding.
How we can do it in excel!
• Do the summation for all item value, suppose the value comes in C7
• Put paid amount in cell C8
• Write formula in C9 likes “=(C8-C7)" then press Enter
• Result will come 18
Repeat the same thing 2/3 times for more practices.
Suppose we have done lots of shopping, Saturday we have brought something, Sunday something and Monday also something. This is our weekly shopping and now we wants to know how much we spend in a week and how much in average,
1st we will find out the total weekly shopping amount-
• Put your cursor in a empty cell and write =SUM(C10,H10,M10) then press Enter. You will see the amount 220
Now we can find out easily, how much we spend in average-
• Simply remove the word “SUM” and put “AVERAGE”. You will see the value 73.3333
Check the tutorial from attached file
In the tutorial you might have seen 2 comments. Wanna learn how to do that? Just right click on the value; then select "Insert Comment. You can show or hide the comment any time followed by the same way. See the below image to make more understanding.
