Register now or log in to join your professional community.
COUNTIFS(Criteria_range1,Criteria1, Criteria_range2,Criteria2.......(Counts the number of cells specified by given set of conditions or criteris
The importance would be determined by what task you are trying to complete, however, somebody learning to use Excel may want to learn the below formula as a good starting point.
=SUM(number1,number2, ...)
This allows you to calculate the total value of a selection of values.
=COUNT(number1,number2, ...)
This allows you to calculate the number of values in a selection of values
=IF(logical_test, value_if_true, [value_if_false])
This will return a defined response depending on the the result of the specified query. I.e. if cell A1 is greater than10 return the response true, if not return false would be =IF(A1>10,"true","false")
=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
This allows you to look up a particular value in a table and return the contents of any cell to the right of that value, or the value itself should it exist within the table.
some basic formulas are as follows
Formula: =SUM(5,5) or =SUM(A1, B1) or =SUM(A1:B5)
Formula: =COUNT(A1:A10)
The count formula counts the number of cells in a range that have numbers in them.
Formula: =TRIM(A1)
Gets rid of any space in a cell, except for single spaces between words
Formula: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
By far my most used formula. The official description of what it does: “Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify
Formulas: =SUMIF(range, criteria, sum_range), =COUNTIF(range, criteria), =AVERAGEIF(range, criteria, average_range)
These formulas all do their respective functions (SUM, COUNT, AVERAGE) IF the criteria are met. There are also the formulas: SUMIFS, COUNTIFS, AVERAGEIFS where they will do their respective functions based on multiple criteria you give the formula.
for combining data in2 (or more) different cells into one cell. This can be done with the Concatenate excel formula or it can be done by simply putting the & symbol in between the two cells. If I have “Christine” in cell A1 and “Chambleri” in cell B1 I could put this formula: =A1&” “&B1 and it would give me “Christine Chambler”.
