Excel problem

[Vinni420]

Hi.

I have a problem with making this apply all result that i have coded in. This one is writen in norwegian.

=HVIS.SETT(OG(J13="Gdansk";K13="Norfolk");B8;OG(J13="Gdansk";K13="Jacksonville");C8;OG(J13="Gdansk";K13="New Orleans");D8)

=SUMIFS(AND(J13="Gdansk";K13="Norfolk");B8;AND(J13="Gdansk";K13="Jacksonville");C8;AND(J13="Gdansk";K13="New Orleans");D8)

It partial gives me the soulotions. It gives me the results for B8 and C8, but not D8. Why is that happening?

Regards Vinni

[#2]

@Vinni420 Took your Norwegian formula. Translated it to English and it seems to work as you expect it to.

=IFS(AND(J13="Gdansk",K13="Norfolk"),B8,AND(J13="Gdansk",K13="Jacksonville"),C8,AND(J13="Gdansk",K13="New Orleans"),D8)

Translated back to Norwegian it's like this, exactly the same as you original formula.

=HVIS.SETT(OG(J13="Gdansk";K13="Norfolk");B8;OG(J13="Gdansk";K13="Jacksonville");C8;OG(J13="Gdansk";K13="New Orleans");D8)

Attached a file with a working formula.