Blogtrottr
Changes are afoot at Blogtrottr! |
By popular request, we're bringing in paid plans with some cool new features (and more on the way). You can read all about it in our blog post. |
|
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決 |
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決 |
|
請教excel函數問題,如何計算每個人完成的工作數量?
Jul 9th 2013, 03:47
如果您的OFFICE版本是2007以後的 可以在D2輸入=COUNTIFS(B$2:B$8,B2,C$2:C$8,"OK") 這是比對範圍內符合條件的函數 公式解說 =COUNTIFS(範圍1,比對條件1,範圍2,比對條件2) 比對條件可以是儲存格、數字、文字(文字前後要加"符號) 如果是2007以前的版本可以採用意見回覆的答案
參考資料 我的腦袋瓜
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. Five Filters recommends: 'You Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html
|
|
|
qhhzl8o1t2dfz
線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍
qhhzl8o1t2dfz 發表在 痞客邦 留言(0) 人氣()
留言列表