I have taken over an Excel training from a coleague, where I have to show array calculations.
This is all fine, and the exercise Works fine apart from the last part.
I have a report with customer sales (Omsætning) and calculate the customer rebate (kunderabat) as an array formula. this Works fine.
Now I have to calculate the total sum of customer rebate for 4 specific customers. They are listed in Range K8:K11, and I want the calculation done as a new arrayformula in Range L8:L11.
I tried marking all 4 rows and inserting the formula =sum(if(Kunde=K8,Kunderaba
t,0) finishing with CTRL + SHIFT + ENTER. that gives me the result for the first customer in all 4 cells.
I tried to change the formula to =sum(if(Kunde=K8:K11,Kunde
rabat,0) but then I got no result at all
It all Works fine if I do this cell by cell and changing K8 to K9 in the Next cell etc.
What do I do wrong - and can it be solved in other ways?