SUMIFS on filtered data?

[TheEnd117]

I have a set of data: order date, item code, description, qty etc. on one tab, then on another I have a table showing the totals ordered based on 2 criteria (the site code and the item number). All works fine using SUMIFS, but I need this table to change if the data on sheet 1 is filtered, but SUMIFS seems to always look at both filtered and unfiltered rows. Is there anyway to get it to just total the quantity of items when the data is filtered?

 

[Fluff]

Not directly with sumifs, you would either need a helper column, or use the filter function instead.

 

[TheEnd117]

Not directly with sumifs, you would either need a helper column, or use the filter function instead.

Many thanks. I used Subtotal in a helper column to determine whether the row was visable, then used that as one of the criteria in the SUMIFS function. Just didn't know if I was doing it the long way round and there was a simpler method. Many thanks for the quick response and confirmation.

 

[Fluff]

Glad to help & thanks for the feedback.