MS Excel Basic Formula Writing - SumIf
Loading...
Uploaded by nerdenterprises on Jan 18, 2011
Read the entire blog post here:
http://www.lockergnome.com/accounting/2011/01/19/ms-excel-basic-formula-writi...
Watch the original screen cast in my main website here:
http://www.nerdenterprises.com/Web_Casts/MS-Excel-Basic-Formula-Writing-SumIf...
Previously on The Bottom line I showed you how to begin writing some basic formulas using the example of a sales tax computation. I left you with a cliff hanger though because there was an assumption that was operative in the example that might not be realistic in terms of a real life application of this. Specifically the model we set up assumed that every item in our list was taxable. This might work for most retail situations, but what about a contractor who might be invoicing for taxable materials as well as non-taxable labor. In the exciting conclusion to MS Excel Tutorial -- Basic Formula Writing Techniques, I show you how we can take this model a step further and identify taxable items vs. non-taxable while still having sales taxes calculate accurately. The challenge is in the formula that calculates the sales tax. We need a way to tell Excel to add items only if they are marked as taxable and then take that total and apply the sales tax rate. Of course this is easy to do manually by sorting the items and grouping the items but who wants to do that? I want to simply be able to go in and mark as taxable any items that are and have excel do the rest of the work for me!
6:45
Excel Tutorial Using the IF AND and OR Functions Microsoft Training Lesson 27.2by teachucompinc37,664 views- 11:15
MS Excel Basic Formula Writingby nerdenterprises497 views
- 5:09
Excel Basic Formulasby TheExcelOffice3,877 views
- 5:15
Excel Basic Formulas: Sum and Percentageby goaskdebbie15,316 views
- 6:46
Excel basics A2 dollar sign to anchor cells for copy and pasteby carltomh405 views
- 4:31
The =SUMIF() Function in Excelby DannyRocksExcels12,723 views
- 15:14
QuickBooks Tutorial - How to Account For Loans to Your Companyby nerdenterprises2,547 views
- 9:10
Excel 2007 Training - Basic Formulasby TrainSignalInc4,365 views
- 2:00
Basic calculations using MS Excelby jeffstanger153 views
- 7:15
Calculate Corporate Tax Using Excelby MrHero4u3,030 views
- 5:45
Excel 2010 Tutorial Writing Formulas Microsoft Training Lesson 4.3by teachucompinc3,614 views
- 3:41
Excel Simple IFby nicholassquare5,106 views
- 3:25
Excel Tutorial: Absolute vs. Relative Formulasby HowcastTechGadgets291 views
- 9:22
Use the SumIf and SumIfs Functions in Excel to Analyze Accounts Receivable Status Reportby DannyRocksExcels3,384 views
- 10:04
2 Methods For Organizing and Tracking Your Receipts (intro)by nerdenterprises1,068 views
- 27:52
Excel VBA & Pivot Table Items - www.ExcelVBASQL.com 25+ hours of FREE training!by ExcelVBAHelp2,584 views
- 5:46
SUM SUMIF COUNT COUNTIF - Excel for Business - Lesson 3by raycolondotcom64,720 views
- 5:09
How to do basic excel formulasby ZapposHowTo7,711 views
- 2:47
MS Excel 2010 tutorial 2 Creating a basic PivotTableby 141Narendra58 views
- 6:51
Excel VBA Beginner Tutorial - Introduction to the Visual Basic Editorby VBA4Excel56,199 views
Thank you for this guide.
papernaps 1 year ago