SUM, SUMIF, SUMIFS

SUM, SUMIF, SUMIFS

SUM FUNCTION
The Excel SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments.

Purpose - Add numbers together

Syntax
=SUM (number1, [number2], [number3], ...)

 Example


To sum yellow highlighted D2 to D 13
=SUM(D2:D13)

 Result: 7601

 **************************************

SUMIF FUNCTION 

The Excel SUMIF function returns the sum of cells that supplied criteria. Criteria can be applied to dates, numbers, and text using logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.

Purpose - Sum numbers in a range that meet supplied criteria

 Syntax
=SUMIF (range, criteria, [sum_range])

Example

1.Total count of Area named "Badami"
=SUMIF(C2:C13,"Badami",D2:D13)
Result: 2182


Location: Bengaluru, Karnataka, India

Comments

Post a Comment

Popular posts from this blog

COUNT, COUNTIF, COUNTIFS

Image
Count function Summary  The Excel COUNT function returns the count of values that are numbers, generally cells that contain numbers. Values can be supplied as constants, cell references, or ranges. Purpose Count numbers Return value  Count of numeric values Syntax   =COUNT (value1, [value2], ...) Arguments   value1 - An item, cell reference, or range. value2 - [optional] An item, cell reference, or range. Usage notes   The COUNT function returns the count of numeric values in the list of supplied arguments. Arguments can be individual items, cell references, or ranges up to a total of 255 arguments. All numbers including negative values, percentages, dates, fractions, and time are counted. Empty cells and text values are ignored. Example #1 - range In the example shown, COUNT is set up to count numbers in the range B5:B11: =COUNT(B5:B11) // returns 4 COUNT returns 4, since there are 4 numeric values in the range B5:B11. Text values and blank cells are ignored. E...
Read more