SUM
Explore the Flashcards:
Adds up all numbers in a specified range of cells. Syntax: =SUM(range).
![1. SUM.png](https://365datascience.com/resources/flashcards/an0im72zm3t-1-sum.png)
SUMIF
Adds numbers in a range based on a single criterion. Syntax: =SUMIF(range, criteria, [sum_range]).
![2. SUMIF.png](https://365datascience.com/resources/flashcards/i04wjbmpj8-2-sumif.png)
SUMIFS
Like Sumif, but allows for multiple criteria. Syntax: =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...).
![3. SUMIFS.png](https://365datascience.com/resources/flashcards/1e5734hd3kd-3-sumifs.png)
Criteria in SUMIF/SUMIFS
Specific conditions that determine which cells to add, like a certain text or numerical value.
![4. Criteria.png](https://365datascience.com/resources/flashcards/hd8feo0q0j6-4-criteria.png)
Sum Range
The cells whose values are to be added in Sumif or Sumifs functions.
![5. SUM range.png](https://365datascience.com/resources/flashcards/yargyheb7pq-5-sum-range.png)
Criteria Range
The range of cells where Excel looks for the specified criteria in Sumif or Sumifs functions.
![6. Criteria range.png](https://365datascience.com/resources/flashcards/zna32y7gwi-6-criteria-range.png)
COUNT
Counts cells in a range that contain numbers. Syntax: =COUNT(range).
![7. COUNT.png](https://365datascience.com/resources/flashcards/h5cktwaq865-7-count.png)
COUNTA
Counts all non-empty cells (including text and numbers). Syntax: =COUNTA(range).
![8. COUNTA.png](https://365datascience.com/resources/flashcards/uuvwtdgqgd-8-counta.png)
COUNTIF
Counts cells meeting a single specified condition. Syntax: =COUNTIF(range, criteria).
![9. COUNTIF.png](https://365datascience.com/resources/flashcards/mxnvxghr1l-9-countif.png)
COUNTIFS
Similar to Countif, but counts cells meeting multiple conditions.
![10. COUNTIFS.png](https://365datascience.com/resources/flashcards/mljgyopxe9e-10-countifs.png)
Numerical Criteria in COUNTIF/COUNTIFS
Conditions based on numerical values like greater than or less than a specified number.
![11. Numerical criteria.png](https://365datascience.com/resources/flashcards/ij23tqdgnpb-11-numerical-criteria.png)
Text Criteria in COUNTIF/COUNTIFS
Conditions based on specific text strings in cells for counting.
![12. Text criteria.png](https://365datascience.com/resources/flashcards/twzhsjhpb0m-12-text-criteria.png)
Multiple Conditions in COUNTIFS
Ability to use multiple ranges and criteria for complex counting tasks.
![13. Multiple conditions.png](https://365datascience.com/resources/flashcards/i5ak2fxthyh-13-multiple-conditions.png)
Using Quotation Marks in Criteria
How to specify conditions as text strings within quotation marks in COUNTIF and COUNTIFS functions.
![14. Quotation marks.png](https://365datascience.com/resources/flashcards/nv4ptclo1u-14-quotation-marks.png)
VLOOKUP
Retrieves data from a column in a table based on a matching value. Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
![15. VLOOKUP.png](https://365datascience.com/resources/flashcards/okeciabnkpl-15-vlookup.png)
Lookup Value in VLOOKUP
The value in Excel VLOOKUP used to find the corresponding data in a table
![16. Lookup value.png](https://365datascience.com/resources/flashcards/oupreicbqxh-16-lookup-value.png)
Table Array in VLOOKUP
The range of cells containing the data to be retrieved by VLOOKUP
![17. Lookup table.png](https://365datascience.com/resources/flashcards/14s01gic886-17-lookup-table.png)
Column Index Number in VLOOKUP
The column number in the table array from which to retrieve data
![18. VLOOKUP columns.png](https://365datascience.com/resources/flashcards/xu9dg7glx1-18-vlookup-columns.png)
Range Lookup in VLOOKUP
Specifies whether VLOOKUP should find an exact match (FALSE) or an approximate match (TRUE)
![19. False.png](https://365datascience.com/resources/flashcards/ru43xgsli4g-19-false.png)
HLOOKUP
Similar to VLOOKUP, but retrieves data based on a row instead of a column. Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
![20. HLOOKUP.png](https://365datascience.com/resources/flashcards/kwjdds55rn8-20-hlookup.png)
INDEX
Retrieves a value from a specified position within a range. Syntax: =INDEX(array, row_num, [column_num])
![21. INDEX.png](https://365datascience.com/resources/flashcards/9k2xuec86mw-21-index.png)
Array in INDEX
The range of cells where the Index function searches for the specified value
![22. INDEX array.png](https://365datascience.com/resources/flashcards/r2ydrhfc93l-22-index-array.png)
Row and Column Numbers in INDEX
Specifies the exact position in the array to retrieve the value from
![23. INDEX row num, column num.png](https://365datascience.com/resources/flashcards/tt10z06uxce-23-index-row-num-column-num.png)
MATCH
Returns the relative position of an item in a range matching a specified value. Syntax: =MATCH(lookup_value, lookup_array, [match_type])
![24. MATCH.png](https://365datascience.com/resources/flashcards/fg28lji3h6c-24-match.png)
Lookup Value in MATCH
The value for which Match searches within the array
![25. MATCH lookup.png](https://365datascience.com/resources/flashcards/134if8cion6-25-match-lookup.png)
Lookup Array in MATCH
The range of cells where Match looks for the lookup value
![26. MATCH range.png](https://365datascience.com/resources/flashcards/6iq5xmpf1s9-26-match-range.png)
Match Type in MATCH
Determines whether Match finds an exact match (0) or the closest match
![27. MATCH type.png](https://365datascience.com/resources/flashcards/ixrhd0eigq-27-match-type.png)
AVERAGE
Calculates the arithmetic mean of a range of numbers. Syntax: =AVERAGE(number1, [number2], ...)
![28. AVERAGE.png](https://365datascience.com/resources/flashcards/johle737z9-28-average.png)
AVERAGEIF
Computes the average of numbers in a range based on a specific criterion. Syntax: =AVERAGEIF(range, criteria, [average_range])
![29. AVERAGEIF.png](https://365datascience.com/resources/flashcards/2kh5tlyeuq1-29-averageif.png)
MAX
Identifies the highest value in a specified range of numbers. Syntax: =MAX(number1, [number2], ...)
![30. MAX.png](https://365datascience.com/resources/flashcards/0kk65s1xn2ul-30-max.png)
MIN
Determines the lowest value in a given array of numbers. Syntax: =MIN(number1, [number2], ...)
![31. MIN.png](https://365datascience.com/resources/flashcards/ps3dlvvtg7-31-min.png)
CHOOSE
Selects a value from a list based on a specified position number. Syntax: =CHOOSE(index_num, value1, [value2], ...)
![32. CHOOSE.png](https://365datascience.com/resources/flashcards/mbc4k6iz7m-32-choose.png)
Goal Seek
A "What-if" analysis tool in Excel for finding required input values to achieve a specific goal. Part of the Data tab under What-if Analysis
![33. Goal Seek.png](https://365datascience.com/resources/flashcards/nupqilz5nw9-33-goal-seek.png)
LEFT
Extracts a specified number of characters from the start of a text string. Syntax: =LEFT(text, num_chars)
![34. LEFT.png](https://365datascience.com/resources/flashcards/y0ssc0v912-34-left.png)
RIGHT
Retrieves a specified number of characters from the end of a text string. Syntax: =RIGHT(text, num_chars)
![35. RIGHT.png](https://365datascience.com/resources/flashcards/kfvbche3lin-35-right.png)
MID
Selects characters from a text string starting at a specified position. Syntax: =MID(text, start_num, num_chars)
![36. MID.png](https://365datascience.com/resources/flashcards/d14u7ege016-36-mid.png)
UPPER
Converts all characters in a text string to uppercase. Syntax: =UPPER(text)
![37. UPPER.png](https://365datascience.com/resources/flashcards/nubrwerx9pk-37-upper.png)
LOWER
Transforms all characters in a text string to lowercase. Syntax: =LOWER(text)
![38. LOWER.png](https://365datascience.com/resources/flashcards/qukm1o8gfib-38-lower.png)
PROPER
Capitalizes the first letter of each word in a text string. Syntax: =PROPER(text)
![39. PROPER.png](https://365datascience.com/resources/flashcards/yxycc5h0clr-39-proper.png)
CONCATENATE
Joins multiple text strings into one string. Syntax: =CONCATENATE(text1, [text2], ...)
![40. CONCATENATE.png](https://365datascience.com/resources/flashcards/vc8obq0mmua-40-concatenate.png)
ROUND
Adjusts a number to a specified number of decimal places. Syntax: =ROUND(number, num_digits)
![41. ROUND.png](https://365datascience.com/resources/flashcards/7qz1li2g5mm-41-round.png)
IFERROR
Manages errors by replacing them with a specified value. Syntax: =IFERROR(value, value_if_error)
![42. IFERROR.png](https://365datascience.com/resources/flashcards/gfg2bu1q1ph-42-iferror.png)
OR
Evaluates multiple conditions and returns TRUE if any one of them is true. Syntax: =OR(logical1, [logical2], ...)
![43. OR.png](https://365datascience.com/resources/flashcards/q7i47l75ukf-43-or.png)