Displaying Sums In Numbers That Match the Filter (MacMost #1909)



https://macmost.com/e-1909 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.

FOLLOW MACMOST FOR NEW TUTORIALS EVERY DAY
Weekly Email Newsletter — https://macmost.com/newsletter
Twitter — https://twitter.com/rosenz and https://twitter.com/macmost
Facebook — https://facebook.com/macmost

SUPPORT MACMOST AT PATREON
https://macmost.com/patreon

Youtube

Related