|
Need some help finding a function in Excel?
EMAGENIT is here to help. Below is a list of functions you have heard of but are
not 100% sure how to use, functions you boss told you to put into your
spreadsheets, functions that accomplish what your boss wants YOU to accomplish,
and functions that nobody has ever heard of or will ever use. Take a look below
and click on the function you need.
Useful Microsoft Excel Functions
Adds all the numbers in a range of cells.
Great for totaling columns of data.
Adds the cells specified by a given criteria.
Counts the number of cells within a
designate range that meet a given criteria. Great for counting instances or the
number of appearances of an item in your data.
COUNT Function,
COUNTA Function and COUNTBLANK Function
Help
These functions are designed to count the number of numbers, occupied cells
(text and numbers) and blank cells located in a range. They can be used to
figure out a tables boundaries on a worksheet and also as part of a statistical
formula.
Searches for a value in the first column of your
data and returns a
value in the same row from another column in your table. Great for building
pricing tables, looking up values in a table and for merging table information
together.
Returns a value from a range based on row and
column.
Just like VLOOKUP but also allows entire columns and rows to be returned from
your data. It also can look in any column or row in a table, not just the first
Returns the index of an
item (its position) found in a column or row, great for finding headers or names which shift in
position in a table. Use with the INDEX function to create a more powerful
lookup formula than VLOOKUP alone.
The SubTotal function
allows you to ignore hidden rows or columns and do tasks like count, sum, etc...
Great for use with the AutoFilter to obtain totals of filtered lists.
MAX Function and MIN
Function Help
These
functions are used to determine the maximum and minimum values in a range or
from a group of values.
More to come so check back often!
|
