Use SUMIF and SUMIFS to sum with conditions. Learn how to use different types of conditions including dates and multiple criteria for a single range.
Tag Archives: Formulas
Power Comparison
Almost two years ago I signed up to a two year fixed pricing contract for my power prices. At that time I did a power comparison of various electricity providers using Excel. Now I have to repeat the process as the prices will be changing shortly. The Consumer Powerswitch website is very helpful. This is a good opportunity to apply the post on simple formulas. Continue reading
Introduction to Simple Formulas
Understanding formulas opens the door for you to perform calculations in Excel.
This post introduces you to entering simple formulas to perform calculations like adding two numbers or cells together. It also introduces you to the use of the $ symbol for formulas.