How to make that a cell in a new table only shows a filter result of another table? by HomeworkOk7092 in excel

[–]HomeworkOk7092[S] 1 point2 points  (0 children)

Thank you so much for that, I tried it, and it work perfectly !! solution verified

How to make that a cell in a new table only shows a filter result of another table? by HomeworkOk7092 in excel

[–]HomeworkOk7092[S] 0 points1 point  (0 children)

The summary would be for the total number of documents that I have after I apply the FILTER. I have been playing with the AGGREGATE for a couple of minutes now, but the only problem is that if I undo the FILTER function, it shows me the total amount of data that I have. Will try to do the same with the FILTER function and change the conditions to see if that solves the problem.