Sumifs filtered data

Question

Hello,

I have a sumifs formula working well which criteria is a letter, formula is this:

=SUMIFS(O15:O55,H15:H55,"=Q")

I need it to work with filtered data only but I've been trying all examples here but none is working.

could you please help me?

Thank you,

Luis

Answer 1

If I understand your question correctly this video may explain how.

Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functions

SUMIFS Function: Adding with Criteria 36 Examples & SUMIF function, Excel Magic Trick 978

Answer 2

There really isn't enough detail in your message to enable anyone to provide a definitive solution. However, I don't believe you'll have success with SUMIF or SUMIFS (only needed for multiple criteria) because the Sum_Range argument supports only a contiguous range of cells. IOW, if you specify A1:A100 all cells in that range will be included if they satisfy the criteria argument(s) even if they aren't being displayed due to a Filter being applied. You would have to supply multiple Criteria arguments based on the Filter criteria & it would have to be revised for each different session.

One alternative that may work better for you is the DSUM function.

Another possibility is to apply a Table structure to the list & use the Totals Row, but I can't be sure because there isn't enough descriptive information to go on.

Answer 3

Hey,

thank you for your response. The link was y seguí, but I found no information on how to make it work with filtered data.

see, I need the formula to work with the data shown only when I filter the chart by year, for instance.

Regards,

Answer 4

Hey,

I think that this is something that you are looking for, I am wishing that this info will be of some help to you - as given in here - http://chandoo.org/wp/2010/04/20/introduction-to-excel-sumifs-formula/