2016【韓劇】奶酪陷阱劇情簡介及人物介紹奶酪陷阱 EP03 預告奶酪陷阱 線上看奶酪陷阱(捕鼠器裡的奶酪) 第1集

因為excel版本不是2007的關係
在2003的excel沒辦法用COUNTIFS來計數
請問F2如何用在範圍B:C裏面取得符合"小明"銷售為"香蕉"的數量

A-------B----------C ---------- D----------E---------F----------G---------H
1------小明------香蕉--------------------統計------香蕉------鳳梨------蘋果
2------小白------鳳梨--------------------小明--------2----------1----------0
3------小花------蘋果--------------------小白--------1----------1----------0
4------小明------香蕉--------------------小花--------0----------0----------3
5------小白------香蕉
6------小花------蘋果
7------小明------鳳梨
8------小白------香蕉
9------小花------蘋果

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:

• Massacres That Matter - Part 1 - 'Responsibility To Protect' In Egypt, Libya And Syria
• Massacres That Matter - Part 2 - The Media Response On Egypt, Libya And Syria
• National demonstration: No attack on Syria - Saturday 31 August, 12 noon, Temple Place, London, UK