Excel Guides

Counting Only Money Winners in Excel

When it comes to counting money, there are a few different ways that you can go about it. You can either use a physical counting method, or an electronic one. If you're using Excel, then you'll want to use the latter. Here's how to count money winners in Excel:

  1. Open up Excel and create a new workbook.
  2. In the first column, label it "Name." In the second column, label it "Amount."
  3. Start entering in the names of the people who won money. In the amount column, enter in how much they won.
  4. Once you have all of the data entered, you'll need to create a formula to sum up all of the money won. To do this, click on cell C1 and type in "=SUM(B1:Bx)" without the quotation marks. x should be replaced with the number of the last row that contains data. So, if your last row is 10, then x would be 10.
  5. Hit enter and your total will appear in cell C1.

And that's all there is to it! Counting money winners in Excel is a pretty simple process once you get the hang of it.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.