"How To Excel" Mini-Tutorials
by TheExcelAddict.com"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"
## Sum Your Data Based On A ConditionSUMIF is one Excel's many extremely useful worksheet functions.
The uses for this function are almost unlimited, so to help you
understand how it works and how you can apply it, I will describe
a scenario for you.
Let's assume you have a table of daily sales data with columns
containing
In a cell outside the table, here's what your formula might look
like: A function is comprised of arguments that are used to perform the calculation. SUMIF has three arguments.
In the example above, The second argument we need is the Criteria. This can be a constant value, a cell reference or a formula that produces a valid value.
The third argument of the SUMIF function is the Sum Range. This
is In our little scenario, this would give us the total of all sales in our table for John Smith.
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.