.png){kind=logo}
How to Sum a Column for Total Cost Calculation in Excel
Hi! Clay S. I want to calculate the total cost of a table. I added the total cost of a request in a column, but is it possible to then sum the column?
To sum the total cost of a column in Clay after adding the total cost of a request, you can use a formula. Here's how: 1. First, ensure your column with the total cost per request is set to the correct data type: • Right-click the column • Select "Edit Column" > "Select Data Type" • Choose the appropriate numerical data type (e.g., Number or Currency) • Click "Save Settings" 2. Create a new column for the sum: • Right-click on any column header • Choose "Insert Column" > "Formula" 3. In the formula field, use the SUM function to add up all the values in your cost column. For example, if your cost column is named "Request Cost", your formula would be: =SUM(Request Cost) This will calculate the total cost across all rows in the "Request Cost" column. If you need further assistance, please ask to talk to a person for more detailed help.
Source: Select Column Data Type
Sanne B.··No, this is for a row, but I want to have the sum of a whole column.
Settings > Credit Usage = credits per table.
- Sanne B.··
But can I change 'credit' to cost (dollars?)
(cost of plan / credits in plan) * credits used in workbook
- Sanne B.··
But if you use different models of ai, and integration with openai etc, this is not reflecting the total cost right?
Not sure how granular you want to get, you can also calculate the API cost
Or why you want to get so granular
- Sanne B.··
Yes, and if i have for instance 50 rows (50 cells of total cost), I want to make a calculation of the sum of all in my workbook.
- Sanne B.··
I want to keep track of the total costs of all my workbooks seperately
Mark L.··Hi Sanne, thanks for getting in touch. Clay doesn't have any features for column- or table-level calculations. You could add the "Total Tokens Used" and/or "Total Cost to AIProvider" columns as separate columns. After doing that, you could e.g. export to CSV and continue the math elsewhere. That's a bit laborious, but it could get the job done. I like the idea, though, and I know we've been thinking about these sort of higher-level table-wide features. I can share this with our product owners, so we can keep your situation in mind as we build out the roadmap.
- Sanne B.··
Thanks! I thought about the idea of exporting it as well, but you cannot get 'real live' cost data in that case, which would be nice to have and save us some work 😉. Please do transfer the idea to the product team!
Hey there Sanne thanks for the feedback will make sure the team hears about this idea!