The COUNT Function
The COUNT function determines how many number values are contained within its arguments. If an argument is a cell or a range of cells, COUNT identifies how many of the values in that range are numeric. The syntax for COUNT is =COUNT(arguments). The arguments that COUNT takes are cell references, constants or some combination of the two. Like the other functions discussed here, COUNT ignores text, blank cells (not zeros), error values, and logical values.
If B2 contains the number 5, B3 the logical value TRUE, B4 the number 74, and B5 the text NO, then =COUNT(B2:B5) will return the value 2. This is because 2 cells contain number values.
As noted, any of these functions can take other functions as arguments. So the expression =(SUM(C2:C4,AVERAGE(B3,G5)) will find the average of the values in cells B3 and G5, and will add this to the sum of the values in cells C2, C3, and C4.
A fancy word for combining data in 2 (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 “Steve” in cell A1 and “Quatrani”
in cell B1 I could put this formula: =A1&” “&B1 and it would
give me “Steve Quatrani”. (The “ “ puts a space in between what you are combining with the &). I can use =concatenate(A1, “ “, B1) and it will give me the same thing: “Steve Quatrani”
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…”.
Basically, you define a value (the lookup_value) for the formula to
look for. It looks for this value in the leftmost column of a table (the
Hope this helps.
Please best my answer if helpful. Thanks :)
Content will be erased after question is completed.