Apple Event: May 7th at 7 am PT
If I filter a table on a column and then highlight a column the SUM field on the bottom of the screen returns the correct value.
However, if I then add a formula to sum the visible data, the value is incorrect as it includes the hidden (filtered out) values.
Adding to what SG has said…
When you filter a table, the visible rows are controlled by the value in a specific column. Use that column as the test-values and the filter value as condition in your SUMIF formula.
Example: You have a table which you have filtered to show only rows where column B contains "gyro".
You want to sum the values in the visible cells of column G.
Your SUMIF formula will look like this:
Syntax: SUMIF(test-values,condition,sum-values)
Formula: SUMIF(B,"gyro",G)
Regards,
Barry
Adding to what SG has said…
When you filter a table, the visible rows are controlled by the value in a specific column. Use that column as the test-values and the filter value as condition in your SUMIF formula.
Example: You have a table which you have filtered to show only rows where column B contains "gyro".
You want to sum the values in the visible cells of column G.
Your SUMIF formula will look like this:
Syntax: SUMIF(test-values,condition,sum-values)
Formula: SUMIF(B,"gyro",G)
Regards,
Barry
Subtotal is not SUM. SUM works the same in Numbers as it does in Excel.
I just tried Excel's Subtotal functionality. For me it did not ignore hidden values.
Maybe the Categories functionality in Numbers (in Organize menu) will do close to what you want? In some ways it's similar to Excel's Subtitle.
SG
A bit more involved than Excel or Google Sheets...
Both have a SUBTOTAL function that will ignore hidden values without regard to a SPECIFIC test value and condition
Sum of column in filtered table provides answer which includes hidden data.
