2
I have some tables with store names 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 the "SOMARPRODUTO" or "SOMASE"? I tried that but it didn’t work:
=SOMARPRODUTO(('2014:2015'!C3:C3069=Tabela1[@LOJA])*('2014:2015'!D3:D3069="RESULTADO")*('2014:2015'!E3:E3069))
1
It is possible yes. 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, automatically it will do the reference. It’s practically the same as making a form in the same file.
Two images to help you understand.
On youtube you can also find some videos teaching. Watch at least half that.
Browser other questions tagged excel
You are not signed in. Login or sign up in order to post.
Thanks Ricardo, but actually that’s not it. The idea does not resume values from another file but from another spreadsheet. If you notice the formula I compare a Range "C3:C3069" of both the 2014 spreadsheet and the 2015 spreadsheet.
– caezar
It’s the same thing. Only instead of clicking on another file’s spreadsheet you click on another spreadsheet of the same file
– Ricardo
Face this I understand, the problem is to get the specific range in the different spreadsheets. In my formula shows I try the following: Add the range E3:E3069 of the spreadsheet 2014 and 2015 where in the range of C3:C3069 of 2014 and 2015 is contains a specific store and the range of D3:D3069 both in 2014 and 2015 contains "RESULT". Note that I can add a new spreadsheet, for example 2013, as the same format and the sum would include this same value, so I put ":" between the name of the two spreadsheets when I specify the ranges "'2014:2015'! D3:D3069"
– caezar