Blank cells

[Sevrool]

Hello!

=SUMMA(STÖRSTA(C3:V3;{1;2;3;4;5;6;7;8;9;10;11}))

I'm a beginner on this so I hope someone can help me.I have problems when I filled in less than 11 cells.
In the result cell I get invalid value.
Someone who has a good solution?

Best regards Sevrool

 

[FormR]

Hi, welcome to the forum!

You'll need to translate the formula names to your native language settings - but here is an option you can try:

=SUMPRODUCT(LARGE(C3:V3;(COLUMN(INDEX(C3:V3;1):INDEX(C3:V3;MIN(COUNT(C3:V3);11)))-MIN(COLUMN(C3:V3))+1)))

 

[Sevrool]

Thank you so much. Will try this as soon as I can.

 

[Sevrool]

Hello FormR,

It works perfect, thank you for the fast answer and help.