"How To Excel" Mini-Tutorials
by TheExcelAddict.com"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"
## Sum Only Data That Meets A Condition You SpecifyIf you have been using Excel for any length of time, I'm sure you have had a need to sum data in a list that meets a specific condition. For example, let's say you use a spreadsheet to record your expenses, and you categorize your expenses such as Food, Entertainment, Utilities, etc.. Let's assume that your table contains the following information: column A = Date, column B = Cheque #, column C = Category, column D = Amount, and column E = Details. Somewhere outside your table you want to track how much you are spending in each category.
The solution you are looking for can be found with Excel's
The structure (or syntax) of SUMIF is
When you use
In our example table, to calculate the total of all your
Entertainment expenses, somewhere outside your table you could
use the formula
Also, instead of typing the Criteria right into the function, you
could use a reference to a cell that contains your criteria so
you could easily change your criteria without touching the
formula. For example
If you will be copying this formula to other cells, you will need
to make your
Why not print (CTRL+P) this tip and share it with your friends and associates?
| time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.Copyright © 2003 All Rights Reserved by Francis Hayes (The Excel Addict) |

otherwise click here and you'll find lots more time-saving Excel tutorials like this one.