Is it possible to use a "SOMARPRODUCT" to calculate values in several worksheets?

2

I have some tables with names of stores and I would like to know the sums of values of these stores that are in different spreadsheets. Is it possible to do this using "SOMARPRODUCT" or "SOMASE"? I tried this but it's not right:

=SOMARPRODUTO(('2014:2015'!C3:C3069=Tabela1[@LOJA])*('2014:2015'!D3:D3069="RESULTADO")*('2014:2015'!E3:E3069))
    
asked by anonymous 25.11.2015 / 21:07

1 answer

1

Yes, it is possible. Just start writing the form, and when you want the value of another file (it has to be open) just click on a cell of it, it will automatically do the reference. It's practically the same as making a form in the same file.

Two images to help you understand.

Youtubealsofindssometeachingvideos.Watchatleasthalfway dele.

    
25.11.2015 / 21:30