- Excel Explorer
- Posts
- Splitting & Summing at the Same Time
Splitting & Summing at the Same Time
Scattered numbers into totals
Learn AI in Just 5 Minutes a Day
Stay up-to-date with AI
The Rundown is the most trusted AI newsletter in the world, with 1,000,000+ readers and exclusive interviews with AI leaders like Mark Zuckerberg, Demis Hassibis, Mustafa Suleyman, and more.
Their expert research team spends all day learning what’s new in AI and talking with industry experts, then distills the most important developments into one free email every morning.
Plus, complete the quiz after signing up and they’ll recommend the best AI tools, guides, and courses – tailored to your needs.
Today, let's explore how to use the SUM function combined with the TEXTSPLIT formula in Excel to sum up values from a single cell containing comma-separated numbers.
This combination is useful for handling financial records, score tracking, inventory management, or any scenario where numbers are stored as text but need to be summed.
Consider this scenario:
You have sales figures, student scores, or expense records in a single cell, separated by commas. Instead of manually splitting and adding them, you can use TEXTSPLIT to separate the values and SUM to calculate the total automatically.
Here’s how it works:
TEXTSPLIT(A2, ",")
: Breaks a text string into separate numbers based on the comma delimiter.--TEXTSPLIT(A2, ",")
: Converts those numbers from text format into actual numerical values.SUM(--TEXTSPLIT(A2, ","))
: Adds up all the separated values instantly.
This method eliminates manual calculations, works well for various types of data, and provides real-time summation without additional columns or formulas.
Try this method and see how it simplifies working with data in Excel, converting text-based numbers into automatically calculated totals.
The process is as follows,
1. Open the Data Sheet in Excel

2. Type the Formula
=sum(--Textsplit(A2,","))

3. Press “Enter”

4. Drag Down to Autofill

That’s how you can use the SUM function combined with the TEXTSPLIT formula in Excel to seamlessly sum up comma-separated values, making your data clearer, more structured, and easier to manage. Whether you're tracking financial records, analyzing scores, or managing inventory, this method simplifies calculations and ensures accuracy across your datasets.
With this efficient approach, you can enter multiple numbers in a single cell, and SUM + TEXTSPLIT will automatically separate and total them—eliminating the need for manual calculations or extra columns.
No more tedious copy-pasting or complex formulas—mastering this technique will help you streamline data management, boost efficiency, and analyze numerical information effortlessly in just a few simple steps!
We Value Your Feedback
Was this tutorial helpful? Rate it, and let us know how we can improve.
Stay tuned for more Excel tips and tricks in our future issues. If you have any questions or need further assistance, feel free to reply to this email. Happy Managing!!!
Ignore This Text
This letter serves as a formal notice regarding the confidential nature of the documents and information (hereinafter referred to as "Confidential Information") that have been and will be shared between [Your Company Name] and [Recipient's Company] as part of the ongoing discussions related to [describe the project or transaction]. The Confidential Information is disclosed under the strict understanding that it will be used solely for the purpose of evaluating or carrying out the aforementioned project or transaction.
1. Definition of Confidential Information
Confidential Information includes, but is not limited to, all data, materials, products, technology, computer programs, specifications, manuals, business plans, software, marketing plans, financial information, and other information disclosed or submitted, orally, in writing, or by any other media. The information may pertain to [specific industry or field relevant to the transaction].
2. Obligations of Recipient
a. The Recipient agrees to limit disclosure of Confidential Information within its own organization to its directors, officers, partners, members, employees, and/or independent contractors (collectively referred to as "Affiliates") having a need to know and shall not disclose such Confidential Information to any third party (including subsidiaries) without the prior written consent of [Your Company Name].
b. The Recipient agrees to take all reasonable measures to protect the secrecy of and avoid disclosure or use of Confidential Information in order to prevent it from falling into the public domain or the possession of unauthorized persons. Measures shall include the highest degree of care that the recipient utilizes to protect its own Confidential Information of a similar nature.
c. The Recipient agrees not to use any Confidential Information for any purpose except to evaluate and engage in discussions concerning a potential business relationship.
3. Exclusions from Confidential Information
Confidential Information does not include information that:
a. is or becomes publicly known through no breach of this agreement by the recipient;
b. is received from a third party without breach of any obligation of confidentiality;
c. is independently developed by the recipient without use of or reference to the sender’s Confidential Information; or
d. must be disclosed under any statutory, legal or parliamentary obligation placed upon the party making the disclosure, including any stock exchange regulation.
4. Term of Confidentiality
The confidentiality obligations of the Recipient shall remain in effect for a period of [specify period] after the date of disclosure of any Confidential Information.
5. Miscellaneous
This notice is intended as a summary of certain key aspects of the confidentiality agreement and does not disclose all terms and conditions. A formal Non-Disclosure Agreement should be reviewed and signed by the authorized representatives of both parties.
6. Acknowledgement
Please acknowledge receipt of this notice and confirm your agreement to the terms outlined by returning a signed copy of this letter.
instruction and with full authority. This letter serves as a formal legal notice concerning serious deficiencies and failures to comply with established agreements and statutory obligations as identified during our ongoing compliance reviews and subsequent investigations.
Background
As per the contractual obligations established in the agreement dated [insert agreement date], between [Your Company Name] ("the Company") and [Recipient's Name/Company Name] ("the Party"), wherein the Party agreed to [briefly describe the obligations, e.g., provide certain services, deliver specified goods, ensure operational compliance], it has come to our attention that there have been multiple and substantive failures on your part to meet these obligations.
Instances of Non-Compliance
Failure to Deliver as per Agreement Specifications: Contrary to clause [specify], which outlines the requirement for [specific requirements], it was noted as of [specific dates], that:
[Detail specific instances of non-compliance, e.g., delivery of goods which did not meet specified quality standards].
[Further instances].
Repeated Violations: Notwithstanding prior communications addressed to you on [dates of prior communications] requesting immediate corrective measures, there remains a lack of satisfactory action on your part to rectify these breaches. These communications are hereby referenced and annexed to this notice for your review.
Impact of Non-Compliance:
Operational Impact: [Describe how these breaches have affected your business operations, customer relations, etc.].
Financial Impact: Estimated financial losses amount to [specify amount], arising from [explain the basis of the losses].
Legal and Regulatory Impact: Non-compliance has further exposed our Company to risks of [mention any regulatory risks, potential fines, etc.].
Legal Grounds
This notice is issued pursuant to the terms outlined in [reference specific contract clauses and any relevant laws or regulations]. Under these terms, your actions constitute a [type of breach, e.g., material breach], allowing us to invoke [mention the contractual remedies available, e.g., termination of the agreement, seeking of damages, etc.].
Demand for Immediate Action
You are hereby required, within [specify time frame, e.g., 30 days] from the date of this notice, to:
Cease all non-compliant activities;
Take immediate corrective action to rectify all breaches noted herein;
Provide a written response outlining the actions taken to address these issues.
Failure to comply within the stated timeframe will compel us to take further action, including but not limited to:
Formal termination of our agreements;
Initiation of legal proceedings to recover damages and enforce compliance through specific performance or injunctive relief.