How to Get Total Payments in Excel

Next Video:
How to Group the Data in Excel....5

Getting total payments in Excel is a process that will require you to use some pretty specific equations and formulas. Get the total payments in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.

Part of the Video Series: Using Excel
Promoted By Zergnet


Video Transcript

Hi. I'm Ted. Today, I'm going to show you how to get total payments in Excel. This is the kind of thing pretty much anybody with a business wants to be able to do where you might want to total the, if you have got different types of products you want the total payments for all products. Or let's say you've got the payments week by week or month by one month and you want the total for the quarter or the year. So I have this spreadsheet set up here where I have just some made payment numbers and let's just say you're in the poultry business and you've got your weekly payments for chickens, ducks and pigeons, first thing we want to know is we want the total payments for all three different products. So we go over here in column E and we've got it, we're going to have column of the totals and we just click on the total and we say equals and then we click over here on the chicken item and the duck item and the pigeon item and hit return. And then we have the total. Now we want to copy the total to all the other lines so we just come down here and we just drag that down with a cursor at the bottom right of the cell and the formula gets captured down to all the other lines with the inputs updated, the row updates inputted accordingly. So I hope this has been helpful. I'm Ted and today I showed you how to get total payments in Excel. Thanks for watching.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!