Dynamic sumifs function

[koppahollic]

Hi - I am trying to use a sumifs function to dynamically update when I'm filtering on different rows. However, my current formula, =SUMIFS(C:C,B:B,B3), is not updating to reflect the filtered rows. Can anyone help me troubleshoot this? Thx

 

[Joe4]

The SUMIFS function is not affected by filtering. It returns the values meeting the condition, regardless of whether the rows are visible or not.

If you want to exclude the hidden rows from the SUM, add the same condition you are using to include/exclude rows in your filter to your SUMIFS formula.

 

[koppahollic]

The SUMIFS function is not affected by filtering. It returns the values meeting the condition, regardless of whether the rows are visible or not.

If you want to exclude the hidden rows from the SUM, add the same condition you are using to include/exclude rows in your filter to your SUMIFS formula.

is there a more effective formula i should be using instead that takes into account both the values meeting the condition and dynamically update when a filter is applied?

 

[Joe4]

I believe you can use the SUBTOTALS function.
See: SUBTOTAL function - Microsoft Support.

If you are trying to filter and total rows at the same time, perhaps you want to look at using Pivot Tables instead?