Hello ,

I need a formula that search only visible values after filtration with multiple criteria , like AVERAGE IFS but only for visible values. I found a formula that combines AVERAGE IF and SUBTOTAL but you ca only put 1 criteria :

=AVERAGE(IF(SUBTOTAL(3,OFFSET(Table2[[#All],[Time from log to close]],ROW(Table2[[#All],[Time from log to close]])-ROW(Table2[[#Headers],[Time from log to close]]),0,1)),IF(Table2[[#All],[Created By]]="Albena M. Atanasova",Table2[[#All],[Time from log to close]])))

I have tried to put another criteria like this but it dos not work :

=AVERAGE(IFS(SUBTOTAL(3,OFFSET(Table2[[#All],[Time from log to close]],ROW(Table2[[#All],[Time from log to close]])-ROW(Table2[[#Headers],[Time from log to close]]),0,1),IFS(Table2[[#All],[Time from log to close]],Table2[[#All],[Created By]],"Albena M. Atanasova",Table2[[#All],[SEV]],1))))

Could someone please help me?