Sumif with Subtotal when the criteria is filtered

[Pavan.Sada.PS]

Dear Fellas,

Could you please help me solve this pussle. I want to filter the criteria column and the sumif should give output based on the filtered output.

 

[xlstime]

you can refer below url
http://www.mrexcel.com/forum/excel-questions/509428-sumif-countif-visible-cells-only.html

Dear Fellas,

Could you please help me solve this pussle. I want to filter the criteria column and the sumif should give output based on the filtered output.

 

[Pavan.Sada.PS]

Hello xlstime.

Quoted URL is designed when the data is filtered and criteria is standard.. but in my scenario. criteria itself is filtered...

 

[bines53]

Hi Paven,

The solution works only after filtering, the solution with two variations.

David