擅長基本-如何使用有條件總和巫術師

張貼在2007年4月10日在4:34 pm

保證讀其他崗位從擅長講解系列!

如果您是新的擅長和想要學會如何使用它，檢查我其他首先在绝對基本張貼通過點擊在「MS辦公室技巧」在右手菜單。在這個小的講解，我們審閱怎樣您能使用一個得心應手的小的特點執行情況總和擅長。

如此什麼是一個有條件總和？假設您有有些雇員，約翰，大衛，并且Craig和您有有些銷售數據為他們在幾星期中或幾個月在擅長覆蓋，并且您想要為每位推銷員分開地看全面銷售，无需必須使用過濾器或做其他複雜的材料，然後您能使用一個有條件總和和指定情況將使用的和數據求和。

它不是容易的那瞭解當您讀它時，因此我們看一看在例子。假設我們安排以下數據在我們擅長板料：

現在為了得到銷售的總和為正義約翰或正義大衛，您會必須輸入累加函數手工然後選擇每列為那個特殊人! 即然是易受的錯誤并且很多時間浪費。如此我們使用有條件總和。首先默認情況下，因為它沒有使能在擅長，我們需要激活這個特點。

去工具并且點擊 增加ins.

在出來的名單，您應該看複選框為「有條件總和巫術師“. 保證檢查個選擇。

點擊OK和您現在發現選擇為有條件總和在工具菜單之下。您不必須重新開始擅長或如此物。

現在開始，選擇有條件總和為工具菜單。 The wizard has 4 steps and they are kinda straightforward, but it took me even two or three tries before I got the thing to work correctly! So I’ll explain as we go along…Firstly, on step 1 of 4, choose the entire data set including the column headers. You want to choose all the columns because later on you have to tell which column is going to be used for the condition and which column is to be summed up. As you can see, I selected all three columns from row 1 to row 13.

In Step 2 of 4, you are asked which column you want to sum and which column you want to evaluate. Excel was smart enough to choose the “Sales Amount” column as my sum column. However, I had to change the evaluate column to Salesperson and then choose the exact value for which I wanted the sum to be calculated for. In this case, I chose David, so that we can see the sum of David’s sales. Click the Add Condition button to add the condition to the condition list. As you can see, you can add more than one condition, so if you have other columns and you want to filter it down even more, you can do that by just choosing another column and picking a value.

Next, on Step 3, you can choose whether to just put the formula in the sheet or to also put conditional value (David) into the sheet. I just chose the formula.

Finally, just choose where you want the data to be placed on your sheet and you’re done!

And now you have the sales for only David without having to use filters or copy and paste the data somewhere else.

Let me know what other things you would like to learn about by posting a comment!

If you enjoyed this post, make sure you subscribe to my RSS feed!

» Filed Under MS Office Tips

One Response to “Excel Basics - How to use the Conditional Sum wizard”

nyla said on : September 21st, 2007 at 7:49 pm

Hey,

I like your site. I learn a lot of cool things on excel. Can you show how to use advance functions like what if analysis, pivot tables. I need to know more advance functions of excel. It’s hard to find tutorials on those topic categories.

Thanks