## Calculate Commission across Multiple Values

Hi I was hoping you could guide me on how I can calculate my commission based on more than 3 factors. i.e. our company uses 3 different lendcare services (we …

## Calculate Sum of Expediture

I want to automatically reduce a number each time I add a new amount to a list to enable me to see whenever I have spent an amount I will know how much I have …

## Sum If, If Two Numbers Equal a Specified Total

Hello, I hope you can help me with the following problem I am encountering. I have around 2000 rows with a set of 8 different numbers in each row. For …

## Using Excel’s AVERAGE Function in Excel

Microsoft Excel comes with a great function, AVERAGE, that will quickly average a range of cells that you specify. When you average numbers what you are doing …

## Enter a Formula to Compute Total Cost

How to compute the total cost and referring to the rate as an absolute cell

## Excel SUMIF Formula Not Matching Criteria

In a previous post I talked about SUMIF – summing cells based on a condition, in this post I will talk about SUMIF based on not matching a criteria. So …

## Sum the Largest Numbers in a List

Summing the largest numbers in a list can easily be completed by combing the Excel SUM and Excel LARGE functions together into one formula. Doing this will …

## SUMIF Function – Summing Cells using a Condition

In a previous post I talked about how to SUM cells using Excel’s SUM function.  This is a great way to sum cells quickly, but did you also know you can …

## Summing Cells in Range using SUM Function

Before Excel 2007 the maximum number of rows per worksheet was 65000!  And if you had numbers in just a thousand of those, and needed to a total of all the …