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

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
    全站熱搜
    創作者介紹
    創作者 omoss 的頭像
    omoss

    中視聶小倩線上看 , 聶小倩線上看第二集 , 聶小倩 中視 , 聶小倩電視劇 , 聶小倩

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