PDA

Vollständige Version anzeigen : Produktformel?


kats12
17.07.2014, 12:21
Hallo,
leider hab ich jetzt schon einiges Versucht und komme nicht zu der Lösung.
Ich Suche eine Formel für unten anstehendes Dokument.

Formel soll in B4.

Hier soll die Summe aus Spalte F (im Register Daten) stehen, wenn die Nummer aus B1, der Name B2 und das Datum A4 mit den jeweiligen Spalten im Register Daten C (Name) D (Nummer) und B (Datum) identisch sind.

Danke!

Mc Santa
17.07.2014, 12:26
Hallo,

hier mein Formelvorschlag:
<br/><b><em>Tabelle2</em></b><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><colgroup><col style="font-weight:bold; width:40px;" /><col style="width:97px;" /><col style="width:97px;" /></colgroup><tr style="background-color:#99CCFF; text-align:center; font-weight:bold; "><td>&nbsp;</td><td>A</td><td>B</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">1</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">NUMMER</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">1245</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">2</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">NAME</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">TAM</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">3</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:right; ">&nbsp;</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">4</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:right; ">01.01.2014</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">12</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">5</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:right; ">02.01.2014</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">6</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:right; ">03.01.2014</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">0</td></tr></table><br/><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px;font-size:11pt; background-color:#ffffff; width:800px;padding-left:2pt; padding-right:2pt; "><tr style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td colspan="3" > verwendete Formeln </td><td> </td></tr><tr valign="top" style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td> Zelle </td><td> Formel</td><td> Bereich </td> <td>N/A</td></tr><tr><td>B4:B6</td><td>=SUMMENPRODUKT(N(A4=Daten!$B$2:$B$35);N($B$1=Daten!$D$2:$D$35);N($B$2=Daten!$C$2 :$C$35);Daten!$F$2:$F$35)</td><td>&nbsp;</td><td>&nbsp;</td></tr></table><table cellspacing="0" cellpadding="0"><tr style="text-align:left; font-weight:bold; " class="style21"><td style="text-align:left; font-size: xx-small" ><a href="http://excel-inn.de/dateien/vba_beispiele/tabellenanzeige_in_html_addin.zip" >Excel-Inn.de</a></td></tr> <tr style="text-align:left; font-weight:bold; " class="style21"><td style="text-align:left; font-size: xx-small" ><a href='http://Hajo-Excel.de/tools.htm' >Hajo-Excel.de</a></td></tr><tr style="text-align:left; font-weight:bold;" ><td style="text-align:left; font-size: xx-small" >XHTML-Tabelle zur Darstellung in Foren, einschl. der neuen Funktionen ab Version 2007</td></tr><tr style="text-align:left; font-weight:bold; " ><td style="text-align:left; font-size: xx-small" > Add-In-Version 18.01 einschl. 64 Bit</td></tr></table><br/>

Hilft dir das?
VG