- Katılım
- 5 Kasım 2007
- Mesajlar
- 4,727
- Excel Vers. ve Dili
- 64 Bit TR - Microsoft Office 365 - Win11 Home
Merhaba,
"Takım_Hakediş_Toplam" isimli sayfada, "C3:C37" arası kullandığım formüller aşağıdadır,
Bu işlem için Topla.Çarpım yerine makro kullanmak istiyorum,
Gerekli kodu rica ediyorum,
Teşekkür ederim.
=EĞER(YADA($Y$1=1;$Y$1=2);TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$D$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$E$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$F$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$G$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$H$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$I$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$J$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$K$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$L$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52));TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$D$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$E$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$F$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$G$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$H$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$I$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$J$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$K$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$L$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52)))
"Takım_Hakediş_Toplam" isimli sayfada, "C3:C37" arası kullandığım formüller aşağıdadır,
Bu işlem için Topla.Çarpım yerine makro kullanmak istiyorum,
Gerekli kodu rica ediyorum,
Teşekkür ederim.
Kod:
=EĞER(YADA($Y$1=1;$Y$1=2);TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$D$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$E$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$F$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$G$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$H$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$I$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$J$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$K$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$L$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52));TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$D$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$E$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$F$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$G$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$H$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$I$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$J$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$K$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$L$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52)))=EĞER(YADA($Y$1=1;$Y$1=2);TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$D$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$E$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$F$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$G$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$H$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$I$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$J$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$K$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_1NCİYARI!$C$1:$BG$1=$L$2)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_1NCİYARI!$C$3:$BG$52));TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$D$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$E$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$F$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$G$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$H$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$I$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$J$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$K$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52))+TOPLA.ÇARPIM((TAKIM_HAKEDİŞ_2NCİYARI!$C$1:$BG$1=$L$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$2:$BG$2=$C$2)*(TAKIM_HAKEDİŞ_2NCİYARI!$B$3:$B$52=$B3)*(TAKIM_HAKEDİŞ_2NCİYARI!$C$3:$BG$52)))