I would like to choose from dropdown list in L1 (same as J2:J600) and sum up all prices from F with specified value from J.

enter image description here


Try replacing , with ;:

   =SUMIF(J2:J600; L1;F2:F600)

Your country uses , as decimal separator and thus cannot be used in any formula.

Not the answer you're looking for? Browse other questions tagged or ask your own question.