Summewenn Nr und Kategorie

Beiträge zum Forumthread

Beiträge zu diesem Forumthread

Betreff

Benutzer

Hi,
Daten

Formeln der Tabelle

Zelle	Formel
C39	=SUMMENPRODUKT((($A$5:$A$36=123)+($A$5:$A$36=456)+($A$5:$A$36=678)+($A$5:$A$36=9810))($B$5:$B$36=$B39)C$5:C$36)
C40	=SUMMENPRODUKT((($A$5:$A$36=123)+($A$5:$A$36=456)+($A$5:$A$36=678)+($A$5:$A$36=9810))($B$5:$B$36=$B40)C$5:C$36)
C41	=SUMMENPRODUKT((($A$5:$A$36=123)+($A$5:$A$36=456)+($A$5:$A$36=678)+($A$5:$A$36=9810))($B$5:$B$36=$B41)C$5:C$36)
C42	=SUMMENPRODUKT((($A$5:$A$36=123)+($A$5:$A$36=456)+($A$5:$A$36=678)+($A$5:$A$36=9810))($B$5:$B$36=$B42)C$5:C$36)
C43	=SUMMENPRODUKT((($A$5:$A$36=111213)+($A$5:$A$36=141516)+($A$5:$A$36=171819)+($A$5:$A$36=202122))($B$5:$B$36=$B43)C$5:C$36)
C44	=SUMMENPRODUKT((($A$5:$A$36=111213)+($A$5:$A$36=141516)+($A$5:$A$36=171819)+($A$5:$A$36=202122))($B$5:$B$36=$B44)C$5:C$36)
C45	=SUMMENPRODUKT((($A$5:$A$36=111213)+($A$5:$A$36=141516)+($A$5:$A$36=171819)+($A$5:$A$36=202122))($B$5:$B$36=$B45)C$5:C$36)
C46	=SUMMENPRODUKT((($A$5:$A$36=111213)+($A$5:$A$36=141516)+($A$5:$A$36=171819)+($A$5:$A$36=202122))($B$5:$B$36=$B46)C$5:C$36)

Excel Tabellen im Web darstellen >> Excel Jeanie HTML 4
Gruss Jürgen

Hi,
Daten

Formeln der Tabelle

Zelle	Formel
C39	{=SUMME(WENN(($A$5:$A$36=MTRANS(Kategorie!$C$4:$C$7))*($B$5:$B$36=$B39); C$5:C$36))}
C40	{=SUMME(WENN(($A$5:$A$36=MTRANS(Kategorie!$C$4:$C$7))*($B$5:$B$36=$B40); C$5:C$36))}
C41	{=SUMME(WENN(($A$5:$A$36=MTRANS(Kategorie!$C$4:$C$7))*($B$5:$B$36=$B41); C$5:C$36))}
C42	{=SUMME(WENN(($A$5:$A$36=MTRANS(Kategorie!$C$4:$C$7))*($B$5:$B$36=$B42); C$5:C$36))}
C43	{=SUMME(WENN(($A$5:$A$36=MTRANS(Kategorie!$C$8:$C$11))*($B$5:$B$36=$B43); C$5:C$36))}
C44	{=SUMME(WENN(($A$5:$A$36=MTRANS(Kategorie!$C$8:$C$11))*($B$5:$B$36=$B44); C$5:C$36))}
C45	{=SUMME(WENN(($A$5:$A$36=MTRANS(Kategorie!$C$8:$C$11))*($B$5:$B$36=$B45); C$5:C$36))}
C46	{=SUMME(WENN(($A$5:$A$36=MTRANS(Kategorie!$C$8:$C$11))*($B$5:$B$36=$B46); C$5:C$36))}

Enthält Matrixformel:
Umrandende { } nicht miteingeben,
sondern Formel mit STRG+SHIFT+RETURN abschließen!

Excel Tabellen im Web darstellen >> Excel Jeanie HTML 4
Gruss Jürgen

Beliebteste Forumthreads (12 Monate)

15 Beiträge zum Forumthread Beiträge zu diesem Forumthread