Excel 多條件查証一問

2014-06-08 9:36 pm

假設 Sheet 1 資料如下 (若1500項)

貸品號碼__已運送__價格__稅款
ABC123___Yes___100___0
A34D95___Yes___200___0
ABC123___Yes___100___0
ABC123___Yes___200___0
CDE334___Yes___150___0
A34D95___Yes___100___0
ABC126___Yes___0____100
CDE334___Yes___150__100
ABC123___No____100___0
ABC123___Yes___100___0
ABC126___Yes___0_____0

可否使用公式於 Sheet 2 求出以下答案
貸品號碼__已運送__價格__稅款__件數
ABC126___Yes____0_____100__1
ABC126___Yes____0_____0____1
ABC120___Yes____100___0____1
ABC120___Yes____200___0____1
ABC123___Yes____100___0____3
ABC123___Yes____200___0____1
CDE334___Yes____150___100__1
CDE334___Yes____150___0____1

Thx!!

回答 (3)

伴

2014-06-13 4:30 am

✔ 最佳答案

Sheet 2係先排序，後做sumif，你公司請唔請兼職先！

👍 0 👎 0

用戶96645

2014-06-12 11:34 pm

這個情況
用樞紐分析表會好過你入公式

👍 0 👎 0

Lai yin

2014-06-09 4:31 am

其實你想係sheet 2 顯示D咩?

👍 0 👎 0