<table border=1><tr><td align=left valign=center><font size=1 color=red face=verdana><b>Gönderen XL Ver.:</b></font><font size=1 face=verdana> Office 2007 / </font><font size=1 color=red face=verdana><b>OS Ver.:</b></font><font size=1 face=verdana> Windows XP </font></td></tr><tr valign=top><td><table border=0 bgcolor=d4d0c8 cellspacing=1 cellpadding=1 align=center><tr align=center valign=center bgcolor=white><td bgcolor=d4d0c8 align=center><font color=black size=2>+</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>A</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>B</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>C</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>D</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>E</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>F</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>G</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>H</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>I</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>J</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>K</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>1</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana><b>İŞLETME GELİRLER TOPLAMI</b></font></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow><b></b></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana><b>OCAK</b></font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana><b>ŞUBAT</b></font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana><b>MART</b></font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana><b>NİSAN</b></font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana><b>MAYIS</b></font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana><b>HAZİRAN</b></font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana><b>TEMMUZ</b></font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>2</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana><b>AY SONU GENEL TOPLAM</b></font></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow nowrap=true align=right><font size=1 color=black face=verdana><b>40.022,43</b></font></td><td bgcolor=yellow nowrap=true align=right><font size=1 color=black face=verdana><b>50.904,97</b></font></td><td bgcolor=yellow nowrap=true align=right><font size=1 color=black face=verdana><b>60.817,28</b></font></td><td bgcolor=gray nowrap=true align=right><font size=1 color=black face=verdana><b>68.107,78</b></font></td><td bgcolor=gray nowrap=true align=right><font size=1 color=black face=verdana><b>75.299,43</b></font></td><td bgcolor=gray nowrap=true align=right><font size=1 color=black face=verdana><b>77.970,93</b></font></td><td bgcolor=#CCCCFF nowrap=true align=right><font size=1 color=black face=verdana><b>80.858,18</b></font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>3</font></td><td bgcolor=white nowrap=true align=center><font size=1 color=black face=verdana><ACRONYM title='=KAYDIR(D1;0;BAĞ_DEĞ_DOLU_SAY(E4:P4))'>EYLÜL <b>(ƒx)</b></ACRONYM></font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Sonu Toplam</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NAKLİ YEKUN</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>32.513,93</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>40.022,43</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>50.904,97</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>60.817,28</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>68.107,78</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>75.299,43</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>77.970,93</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>4</font></td><td bgcolor=white nowrap=true align=center><font size=1 color=red face=verdana><b><ACRONYM title='=KAYDIR(D1;1;BAĞ_DEĞ_DOLU_SAY(E4:P4))'>86.872,26 <b>(ƒx)</b></ACRONYM></b></font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AY TOPLAMI</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>7.508,50</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>10883</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>9.912,31</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>7.290,50</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>7.191,65</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>2.671,50</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>2.887,25</font></td></tr></table></td></tr><tr><td bgcolor=f0f8ff align=center><font color=black size=1 face=verdana><b>XLtoHTML v1.1 / OfficeTürkiye - 2010©</b></font></td></tr></table>
Dosyanızda toplam satırı eğer 2. satırda ise ilgili hücreye aşağıdaki şekilde yazınız.
=KAYDIR(D1;1;BAĞ_DEĞ_DOLU_SAY(E4:P4))2. sorunuza gelince bu bir Excel eklentisi ile yapılmaktadır.Eğer sitede konum olarak ayarlıya bilirsek paylaşırım.
