excel - Filter table data in function -


i've created dashboard worksheet performs calculations on table of data (alldatamodel). calculations prevent me using pivot tables.

i've applied slicer data table date. while table data appears updated, calculated data isn't updating. how calculated fields use filtered table data?

example calculation:

=sumif(alldatamodel!$b$2:$b$65536,concatenate("*",c27,"*"), alldatamodel!$g$2:$g$65536) 

a solution can found search keywords excel sumif filtered range. there many sites , videos available explain this.

in case should be:

=sumproduct((subtotal(9,offset(index(alldatamodel!$g$2:$g$65536,1),row($2:$65536)-row(alldatamodel!$g$2),0)))*(not(iserror(search(c27,alldatamodel!$b$2:$b$65536))))) 

Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -