Function and Sub in Excel VBA

Excel VBA | sum() functions

Last Updated : 29 Sep, 2022

Visual Basic for Applications (VBA) is the programming language of Excel and other offices. It is an event-driven programming language from Microsoft. With Excel VBA one can automate many tasks in excel and all other office software. It helps in generating reports, preparing various charts, graphs and moreover, it performs calculation using its various functions. Let's see Sum functions in Excel.

SUM: Adds all the numbers in a range of cells. Syntax:
```
=SUM(number1, number2…)
```
Here, number 1: This is the first number in your cell to add. You can specify it upto 255 numbers. number 2: This is an Optional field. You can add upto 255 numbers. Example: Output:
SUMIF: Allows to add the cells depending upon the criteria you’ve provided. Syntax:
```
=SUMIF(range, criteria, sum_range)
```
range: It is the range of cells which you want to evaluate. The cells in range can be numbers, names or arrays or any other reference that contains numbers. criteria: It should be in the form of a number or any expression which defines which all cells to be added.
```
For instance, “mango”, C6, “<35”
```
sum_range: This field is Optional. If this is not mentioned, Excel will add only those cells on which criteria is applied, which are specified in the range argument. Example: Output:
SUMIFS: Allows you to add all the arguments that meet multiple criteria. Syntax:
```
=SUMIFS(sum_range, criteria_range1, criteria1 [criteria_range2, criteria2], …)
```
sum_range: (Required) Actual cells to sum. criteria_range1: (Required) criteria_range1 and criteria1 makes up a search pair through which a range is searched for some specific criteria. When elements in the range are located, their corresponding values in sum_range are added. criteria1: This defines which all cells in criteria_range1 are to be added.
```
For instance, criteria can be like this, “>32”, “apple”, “D7”
```
Example: Output:

Function and Sub in Excel VBA

aishwarya.27

Improve

Article Tags :

Misc
Excel

Practice Tags :

Misc

Similar Reads

Function and Sub in Excel VBA

In Visual Basic, the functions and sub-procedures play similar roles but have different or unique characteristics. However, both perform a programmed task. They utilize a set or group of commands to deliver the required results. The key difference between the sub and the functions is that a sub-proc

Excel VBA | count() functions

Visual Basic for Applications (VBA) is the programming language of Excel and other offices. It is an event-driven programming language from Microsoft. With Excel VBA one can automate many tasks in excel and all other office software. It helps in generating reports, preparing various charts, graphs a

Excel VBA | Average() Functions

VBA (Visual Basic for Applications) is the programming language of Excel and other offices. It is an event-driven programming language from Microsoft. With Excel VBA, one can automate many tasks in excel and all other office softwares. It helps in generating reports, preparing various charts, graphs

InputBox Function in Excel VBA

Input Box is one of the most frequently used functions in VBA Macro. The dialogue box that appears asks for input from the user and returns a constant/code/number/text. For example, if you want to create a log-in form in VBA, you will require an input box function. Let's learn how to create an input

Excel IF Function

The IF function in Excel is one of the most powerful and commonly used formulas that allows you to perform logical tests and return different values based on whether the condition is true or false. If youâ€™ve ever needed to check whether a value meets certain criteria, then the IF function is the too

VBA Date and Time Functions in Excel

Date and Time Functions are the inbuilt functions that give us the opportunity to see the date or time according to the user's need. Suppose a user needs to see the month or the day or the year then it can be easily seen by different date functions. Similarly, for the time function, also we can mani

VBA Strings in Excel

In Excel's Visual Basic for Applications(VBA), strings are pivotal in handling and manipulating text-based data. Strings serve as a fundamental data type used to store a sequence of characters, enabling the representation of textual information, numbers, symbols, and more. Understanding how VBA hand

Normdist() Function in Excel

The NORMDIST Function is one of Excel's Statistical functions. For a given mean and standard deviation, it will yield the normal distribution. That is, for a given set of parameters, it will compute the normal probability density function or the cumulative normal distribution function. In this artic

Introduction to MS Excel

Since the release of the first version of Excel in 1985, this spreadsheet program has received various updates, and nowadays it is one of the most used spreadsheet programs. But the question is, what is actual Microsoft Excel? What are the use cases of this spreadsheet program?This introduction guid

Excel DATEDIF Function

The DATEDIF is a date function that is generally used to find the number of total days, months, and years between two dates. It takes two dates as an argument with one keyword to specify which type of difference is required as an output. The output of the function will always be an integer form. Dat