[請問] excel不等於xx的總合:－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

批踢踢實業坊 ask 板

Need cooking inspiration?

Have a passion for cooking delicious meals or need inspiration for your next dish? Daily food fares to quench your palette when you subscribe to Recipe ideas.

From our sponsors

[請問] excel不等於xx的總合

Sep 9th 2013, 10:22, by aastoy

作者aastoy (Scat)

看板ask

標題[請問] excel不等於xx的總合

時間Mon Sep 9 10:22:48 2013

請問excel中欄位 A B C D 1 甲 2 乙 4 2 丙 1 丁 5 3 忠 2 孝 3 4 仁 4 愛 8 目前公式已有設SUMIF($A1,"甲",$B1)+SUMIF($C1,"乙",$D1) 可以算出總合為6 但如果我要計算除了甲、乙、丙、丁外其它的總合我要怎麼列公式呢？ PS 除了甲乙丙丁外，其餘全統一列為"其它"就好試問我該怎麼列公式會比較好？網路上有查到不等於是，可是不知道該怎麼計算總合麻煩知道的大大幫忙，謝謝 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 211.22.145.125

推 lion21:sum()-sumif(甲乙丙丁) 09/09 10:28

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

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