# Calculate each cell's percent total of column

#### Step 1: Import unicorn startup valuation data 

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. 

{% file src="/files/U2TijPiyVP5CGNmX6Vxx" %}

<figure><img src="/files/irDhPqt8GP0X6RPLUZd5" alt=""><figcaption><p>Unicorn startup valuation data</p></figcaption></figure>

#### Step 2: Calculate the percent total of each row&#x20;

Create a new column and write the formula in the first cell.&#x20;

`=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.&#x20;

<figure><img src="/files/bAR7tRbRKdfKywh1wCG1" alt=""><figcaption><p>Writing the formula to calculate the percent total of each row</p></figcaption></figure>

#### Step 4: View the results

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.&#x20;

<figure><img src="/files/QHck6mMnetOGspdcYhMZ" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/M76hSnXWzkfnZ61kmkm2" alt=""><figcaption></figcaption></figure>

For more information on Mito spreadsheet formulas, check out the [spreadsheet formula reference](/how-to/interacting-with-your-data.md).&#x20;


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.trymito.io/how-to-1/calculate-each-cells-percent-total-of-column.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.