formula pre dali:
[hore]SUMIF($B$3:$B$18,$M3,$C$3:$C$18)+SUMIF($F$3:$F$18, $M3,$G$3:$G$18)+SUMIF($J$3:$J$18,$M3,$K$3:$K$18)
formula pre dostali
SUMIF($B$3:$B$18,IF(INDEX($B$3:$B$18,MATCH(M3,$B$3 :$B$18,0)+1,0)<>0,INDEX($B$3:$B$18,MATCH(M3,$B$3:$ B$18,0)+1,0),INDEX($B$3:$B$18,MATCH(M3,$B$3:$B$18, 0)-1,0)),$C$3:$C$18)+SUMIF($F$3:$F$18,IF(INDEX($F$3:$ F$18,MATCH(M3,$F$3:$F$18,0)+1,0)<>0,INDEX($F$3:$F$ 18,MATCH(M3,$F$3:$F$18,0)+1,0),INDEX($F$3:$F$18,MA TCH(M3,$F$3:$F$18,0)-1,0)),$G$3:$G$18)+SUMIF($J$3:$J$18,IF(INDEX($J$3:$ J$18,MATCH(M3,$J$3:$J$18,0)+1,0)<>0,INDEX($J$3:$J$ 18,MATCH(M3,$J$3:$J$18,0)+1,0),INDEX($J$3:$J$18,MA TCH(M3,$J$3:$J$18,0)-1,0)),$K$3:$K$18)
/M