Combining the SUBTOTAL function with COUNTIF is not possible?

It is difficult to give you a good answer without knowing the details.

Will you filter based on the content of the row?

If yes you could try COUNTIFS, this will allow you to count only rows that meet multiple criteria.

Content of this row in column A and content of this row in column B, only if both are met this row will count.

Would be helpful if you could post a screenshot of your table, please remember to remove confidential information.

Ralf

Hi RubenVDV,

Hope I got it right.

I created only a small section of your large table to show how it can work.

Please try this

A2=COUNTIFS(Table 4::A,"Bags 5",Table 4::B,">0") or COUNTIFS(Table 4::A;"Bags 5";Table 4::B;">0")

COUNTIFS will only count rows that meet both tests

A: Text in column A = Bags 5

B: Value in column B is >0

Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.

Hope this will solve your question, please let me know if this worked for you or if something in unclear.

Regards Ralf

Hi Ruben,

you could create a Pop-Up Menu with your different option and change the formula to include the result of this Pop-Up cell.

A2=COUNTIFS(Table 4::A,A3,Table 4::B,">0")

Filter and SUBTOTAL are a nice tool, unfortunately they will not always work good with other formulas.

Ralf