» Summing a range containing errors and values in Microsoft Excel
CATEGORY: Summing |
VERSIONS: All Microsoft Excel Versions |
|
The solution to summing a range that contains
errors covers errors of type #VALUE! Enter the following formula in cell A5: =SUMIF(A1:A3,"<>#VALUE!",A1:A3) The Result: 30 |
Book Store:
Recommended Books:
- Definitive Guide to Excel VBA
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Windows XP for Dummies
- Now, Discover Your Strengths
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.





