Forum Discussion
Linking Tabs to Sum
That is not so difficult. If you want to work with a pivot table in the future, you will need the formula in column L because the shop information can only be found in the CC. The formula I wrote will also work in any other of your worksheets as long as you have the table CC with the same range CC!$A$3:$R$46 of data. If necessary you have to adapt it.
If you have the data then you need to select the data range and then create the pivot table. Try that out. It is not difficult. I'm sure there are many good documentations on the internet and YouTube on how it works.
You still have to make some settings so that it looks exactly like in my example. But with a little trial and error, you're sure to get it right.
That is not so difficult. If you want to work with a pivot table in the future, you will need the formula in column L because the shop information can only be found in the CC. The formula I wrote will also work in any other of your worksheets as long as you have the table CC with the same range CC!$A$3:$R$46 of data. If necessary you have to adapt it.
If you have the data then you need to select the data range and then create the pivot table. Try that out. It is not difficult. I'm sure there are many good documentations on the internet and YouTube on how it works.
You still have to make some settings so that it looks exactly like in my example. But with a little trial and error, you're sure to get it right.
You must always fill the SEQUENCE() part with the number of columns in CC. In this case 103.
=LET(cn,SUM(MMULT(--(J2=CC!$A$3:$CY$60),SEQUENCE(103))),IF(cn=0,"without shop",INDEX(CC!$A$2:$CY$2,cn)))dscheikey I started working on this with all of the April data... and I can't get my Shop formula to work. What did I do wrong?