close
Blogtrottr
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中 
Get the newest, latest, hottest

Find shoes, heels, flats, active, essentials and more in the latest styles. Save up to 40% on select items.
From our sponsors
Excel 指定對應數值的相加公式。
Apr 16th 2014, 21:27

參考附件︰http://www.FunP.Net/506378

R欄值不會重複。

需求︰
當Y7<>""時，則將Z7和(=X7的R欄數值之X欄對應數值)相加，
並將其和値顯示在AA7的儲存格中。
EX︰
AA13=IF($Y13<>"",$Z13+$X11,"")
即
=X13(=21)的R欄數值(=R11)之X欄對應數值(=X11=21)
AA13=$Z13+$X11=88+21=109

AA41=IF($Y41<>"",$Z41+$X35,"")
即
=X41(=184)的R欄數值(=R35)之X欄對應數值(=X35=180)
AA41=$Z41+$X35=81+180=261

其餘………以此類推

請問：
AA7的下拉函數公式要如何撰寫?謝謝!


This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.
You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions
arrow
arrow
    全站熱搜
    創作者介紹
    創作者 marccmpt 的頭像
    marccmpt

    信貸利率, 個人信貸, 小額信貸, 信貸試算, 信貸銀行, 信貸條件, 信貸比較, 中國信託信貸, 公教信貸, 信貸利率最低

    marccmpt 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄