## Personal Mileage

Hello, Please help i am currently trying to figure out the best formula to use when calculating cumulative mileage claims, for example if Mr A has driven 9500 …

Hello, Please help i am currently trying to figure out the best formula to use when calculating cumulative mileage claims, for example if Mr A has driven 9500 …

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 …

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 …

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 …

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 …

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

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 …

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 …

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 …

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 …