I have this formula it gets the single data from another file from a sheet at column 7.
=ARRAYFORMULA( if( len($A2:$A); iferror( vlookup( $A2:$A; importrange('Aylar ve Linkler'!$B$7;"Grafik Data'!$C3$:$J$108"); 7;0); "mağaza yok") ;) )
But the stores
vlookup($A2:$A) on the other file's
Grafik Data'!$C3$:$J$108sheet at 7th columns has 2 values and i want to sum them.
I mean when i look for store names on other file, there are 2 same store names with 2 different values. I would like to get
sum of them.