[請問] Excel函數疑問:－2016 台北日本料理推薦 , 台北日本料理吃到飽 , 台北日本料理名店 , 台北日本料理吃到飽推薦 , 台北日本料理推薦2014

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.

批踢踢實業坊 ask 板

[請問] Excel函數疑問

Jun 30th 2013, 13:26, by seazilicy

作者seazilicy (萬事要隨緣)

站內ask

標題[請問] Excel函數疑問

時間Sun Jun 30 13:26:38 2013

用殘體字先說抱歉，我開放用噓文回答我的問題人在中國身不由己，用pcman打繁體中文會變成亂碼請問我要使用excel函數，目的是要統計「空房總數」 A B C D 1 101號房 103號房 105號房 107號房 2 小明大王小陳 3 小英 4 假設有四間房間，如果要統計總入住人數，可以使用 Counta(A2:D4) 但是請問我如果想要統計空房總數，要用哪個函數呢？順便請問，如果我想要統計非空房總數，要用哪個函數呢真對不起~"~ 殘體字讓大家看了不蘇胡 -- 推 DexterMorgan:如何取悅四叉貓？ 05/17 18:18 推 XXXXGAY:1F脫光就可以了。 05/17 18:44 → i19890813:一樓糗了 05/17 19:24 推 tom928:1F祝你平安 05/17 19:26 推 soulempty:一樓XD (原PO空氣化了 05/17 19:49 推 nsysufish:1F被盯上了!!! 進擊的四叉貓!!! 05/17 20:02 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 114.34.135.161

→ tn00210585:有人住=0 沒人住=1 SUN= 06/30 13:28

→ seazilicy:那要怎設定A2:A4皆非空白時為1呢？ 06/30 13:36

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