Filter Tool vs Filter Function

preview_player
Показать описание
LEARN:
Рекомендации по теме
Комментарии
Автор

use subtotal instead of sum, still you can use filter :)

VinayKumarModi-xc
Автор

how to deal with comma separated values [100+] like a, b, c and x, y, z in second row. I want a, b, c, x, y, z values in six rows one letter in each row. This is without using power query

rangarajanbalakrishnan
Автор

Let's say I'm using the filter function only, but I need the total below every selection. The data will not be the same, and I need to move the sum function every time I change any options. Right now i have total cell above heading any other option

suddu_shetty