# Calculate each cell's percent total of column

This tutorial shows how to use full column references to calculate each cell's percent total of the column

In this example, we're going to look at which unicorn startups contribute most to the unicorn startup market cap.

To follow along, download the data here.

Unicorn_Startups.csv

26KB

Text

Unicorn startup valuation data

Create a new column and write the formula in the first cell.

`=Valuation_Billions0/SUM(Valuation_Billions:Valuation_Billions) * 100`

Notice that the formula calculates the SUM of the valuation column using range syntax just like Excel.

Writing the formula to calculate the percent total of each row

Once the formula is applied, check out the results. Here I sorted and graphed the data so we can see the startups that contribute the most to the market cap of Unicorns.