2013 update. Summing and counting values are the most common spreadsheet operations, and Excel's capabilities go far beyond routine SUM and COUNT formulas. Author Tim Hill shows you how to use worksheet functions, array formulas, AutoSum, and other Excel features to summarize an entire range of values, or only values that meet specific conditions. If you're using an older version of Excel that doesn't support the latest worksheet functions, you'll find equivalent formulas that work in Excel 2003 or earlier. You can download the sample workbook to follow along with the author's examples.
- Covers all versions of Excel, including Excel 2013.
- Display sums and counts without using formulas.
- Master the basics of COUNT, COUNTA, COUNTBLANK, and other counting functions.
- Create conditional counts with COUNTIF and COUNTIFS.
- Calculate the mode for numeric or text values.
- Count unique values in a range.
- Count occurrences of specific text strings.
- Create frequency distributions and histograms.
- Master the basics of the SUM function.
- Use AutoSum to sum values quickly.
- Calculate running totals.
- Sum only the highest or lowest values in a range.
- Eliminate rounding errors in financial calculations.
- Sum every Nth value in a range.
- Create conditional sums with SUMIF and SUMIFS.
- Plenty of tips, tricks, and workarounds.
- Fully cross-referenced, linked, and searchable.
Contents
- Getting Started with Sums & Counts
- Counting Basics
- Counting Tricks
- Frequency Distributions
- Summing Basics
- Summing Tricks
Per maggiori informazioni: l'eBook "Mastering Excel Sum & Count Formulas (No Fluff Guide)" di Tim Hill, edito da Questing Vole Press, è in vendita in formato Kindle su Amazon.it al prezzo di Euro 3,08
.
Nessun commento:
Posta un commento