You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria. Filters are a ...
Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...
Kenji Explains on MSN
I discovered the Excel function you need!
The SUBTOTAL function in Excel is a powerful alternative to SUM, AVERAGE, and MIN, particularly when working with filtered data or hidden rows. Unlike SUM, SUBTOTAL adjusts dynamically to display only ...
Filtering in Excel allows you to organize your data in multiple ways. Using a filter, you can cut down the amount of data shown on your sheet based on the values for either a certain selection, such ...
How-To Geek on MSN
You need to know what the tilde (~) does in Excel
The tilde isn't the only sign you need to understand to truly get your head around Excel's inner workings. For example, the at (@) sign returns a single row value instead of spilling an array, the ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback