Over years of working with Excel, I have stumbled upon a collection of functions that have transformed my workflow. These aren't your basic SUM and AVERAGE formulas; these are the hidden gems that can ...

So you export the relevant data into Excel, where you use the SUMIF function [SUMIF (range, criterion, sum_range)] ... In this example, the salesperson for each transaction is listed in cells A3 ...

The SUMIF function in Excel is used to add all the cell values and return the results on the basis of one criterion. ... Now read: 10 Text functions in Excel with examples.

For example, to determine if the value in cell B2 is greater than five, ... There are also more complicated functions in Excel that can sum or count values when certain criteria are met.

After calculating percentage markups, you can use the SUM() function in Excel to add the markup values to the original value. For example, if your wholesale item costs $10 and the markup is 25 ...

Image: iStockphoto. Most Microsoft Excel functions are autonomous—one result value for each function or formula. For example, you might use SUM() to return the sum of all the values in a single ...