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))