When you add or subtract currency-formatted numbers, Excel 2013 automatically adopts the currency format for the results. Adding and subtracting figures follows similar procedures, but you must be ...
There might be some numbers you're missing when summing it up.
How-To Geek on MSN
Master Excel's Total Row for better data insights
Excel's Total Row uses smart SUBTOTAL logic to ignore hidden data, adapt to filters, flag text errors, and measure performance volatility.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results