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?