Download the featured file here: [ Ссылка ]

In this Microsoft Excel video tutorial I explain how to sum up numbers stored in a single cell. Multiple numbers stored in one cell are normally separated by a delimiter such as a comma. If you are using Excel 365 you can sum these numbers using a combination of the SUM and TEXTSPLIT functions. If you are using an older version of Excel, one way of summing the numbers is to create a custom VBA function.

00:00 Introduction
00:35 Use SUM and TEXTSPLIT (Excel 365 users)
02:14 VBA Function 'CELLSPLIT', (code below)

Function CELLSPLIT(cell As String, delimiter As String)
CELLSPLIT = Split(cell, delimiter)
End Function

свернуть