MS Excel打翻并且欺騙-如何計數事擅長
張貼在2008年2月8日在6:43上午
保證讀其他崗位從擅長技巧系列!
有認為大多數我們仅用途大約我們的腦子的百分之十的老妻子』傳說。 很好，那是poppycock。 但什麼是真實的是大多數我們用途少於力量的10%在我們昂貴的微軟辦公系統應用。 作為例如擅長。 我愛擅長。 如果您在世界上可能得到最可怕的工作，并且推測方式使用擅長做它，我認為我會發現它樂趣。
人們經常問我怎麼我學會了擅長。 我通過撇取大開始了，肥胖 如何使用擅長指南有什麼樣的事想法我可能做以它。 如果我可能我可能做特點的設想用途，我學會了如何利用它。 以後它是正義學會通過做。 但足够關於我。
其中一個最強有力的特點可利用 擅長是對慣例的它的用途. 在擅長報表的每個細胞您能輸入數據，像數字或文本。 您能也進入慣例，并且慣例在其他細胞可能做幾乎任何東西以數據。
在這個崗位我將顯示您 如何使用一個簡單的慣例計數事擅長. 我們提出問題： 您有其中每一位把某一金額他們欠您從不同的時期他們借用朋友的名單。 那是不錯，您是像銀行。 如此您的名單如下所示:
現在，如果這是您的Shylock方式的充分的程度，您可能把多少加起來每個朋友欠您。 但，如果您有很多這種材料繼續和您想要自動化增加什麼的過程每個人欠，您可能設定您的報表做它為您，像這樣：
如此什麼慣例導致的總和欠債量由每個朋友？ 簡單： SUMIF . Using the SUMIF formula, I set up a little table that automatically calculates the sum totals owed by each friend.
Here’s what I did: I made a list of my friends in Column E. Then in cell F2 I entered the following:
=SUMIF($B$2:$B$9,”Mike”,$C$2:$C$9)
In the next cell down,
=SUMIF($B$2:$B$9,”Janet”,$C$2:$C$9),
and so on, only changing the name for Excel to use as its criterion. What you are telling Excel to do is, look in the range B2 to B9 (the $ signs make it so you can copy the formula without the range being changed); if it sees the word Mike, it should include the adjacent amount in the range C2 to C9 it its sum. Simple.
If you think about it you can probably think of some ways you can use the SUMIF formula. But you should only use this power for good, not evil.
If you enjoyed this post, make sure you subscribe to my RSS feed!
» Filed Under MS Office Tips
Related Posts
- Excel Tutorial - Example of how to use the VLOOKUP function
- Microsoft Excel Basics Tutorial - Learning how to use Excel
- Master Excel Tables with AutoFilter and Subtotal
- Excel Basics - How to use the Conditional Sum wizard
- How to use Data Validation in Microsoft Excel to create dropdown lists
3 Responses to “MS Excel Tips and Tricks – How to count things in Excel”
Pingbacks
-
Master Excel Tables with AutoFilter and Subtotal Says:
[...] Online Tech Tips posts have already covered clever but unfamiliar functions like VLOOKUP and SUMIF. Now it’s time for another round of Outrageous Excel [...]
August 13th, 2008 at 4:59 pm
Please post your comments/suggestions!
[...] Online Tech Tips posts have already covered clever but unfamiliar functions like VLOOKUP and SUMIF. Now it’s time for another round of Outrageous Excel [...]
August 13th, 2008 at 4:59 pm
Thanks for the helpful tip!
hi there,
can someone help me?
i have a list of a customer name, each customer has many site
when i filter them, i don’t know how many the customer service site?