Get the most from your Mac! The show features news, tips, tricks, techniques, tutorials and reviews geared toward the casual, home and business Apple user. Covers the Mac, iPad, iPhone and other Apple products.
https://macmost.com
Displaying Sums In Numbers That Match the Filter (MacMost #1909)
View in HD at . When you filter rows in Numbers, any totals or other footer calculations will still be based on all of the rows, not just the ones visible. You can change that by using functions like SUMIF that match the filter. But then you need to adjust your formulas and filters every time so they are the same. However, you can use a hidden column and a single-cell separate table to make this quick, easy and useful.