人生若精通excel，何至秋风悲画屏

[TIFF]

你会用excel吗？

A little bit...

 

[idolou]

A little bit...

姐， 要是实在干不动了， 就退休吧。

 

[TIFF]

你会用excel吗？把这个贴在item1 那行的末尾， 试试。

I got 4.

 

[TIFF]

姐， 要是实在干不动了， 就退休吧。

Yes, I am thinking about that, too...

 

[一心无住]

人生若精通excel，何至秋风悲画屏

弄个技术坑也诗情画意。

 

[TIFF]

高人啊，请快出现吧。上次我问另外一个excel问题的时候，知道有几位高手，但愿他们没有离开cfc。

 

[idolou]

上当了。

 

[TIFF]

上当了。

上什么当？

 

[idolou]

上什么当？

你没事坑人玩

 

[TIFF]

你没事坑人玩

Please don't change the subject. So far you have not provided a valid solution to my question. Of course you are not obligated to do so. Nice try, anyway.

 

[coala]

先做一次subtotal，在小计的基础上，做count or filter 可得

 

[mayo_wang]

请问一个excel的问题

用下面这个简单的table做一个例子。如果我想count有多少个region 有item1 和item2， 正确答案是，有item1 的region有两个，US and Canada， 有item2的也是一样。

简单的table容易看，但是如果数据量大，只能依靠function来数。用我已知的count function， 会数重复，会说有item1 的有3个region， 有item2的有4个region。 请问怎么样才能让count不去重复数同样的region？就是要在前面加个判断，如果都是US，只数一次，都是Canada，也只数一次。谁知道啊？先谢谢了。

浏览附件385275

You did not give a clear example.

Item 1 Item 2
USA 5 0
USA 6 0
Can 1 1
Can 0 1
China 0 4
Japan 0 6

So you want get 2 in the column of Item 1 (since there are 2 regions having positive numbers of Item 1) and 3 in the column of Item 2 (since there are 3 regions (Can, China, Japan) having positive numbers of item 2), right?

 

[idolou]

Please don't change the subject. So far you have not provided a valid solution to my question. Of course you are not obligated to do so. Nice try, anyway.

我是个实在人， 要帮人就认真的帮。 我试过了， 我的方法是对的，答案都是2. 今天我也很2， 明显是坑啊。上当了.

 

[idolou]

I got 4.

how?

 

[TIFF]

You did not give a clear example.

Item 1 Item 2
USA 5 0
USA 6 0
Can 1 1
Can 0 1
China 0 4
Japan 0 6

So you want get 2 in the column of Item 1 (since there are 2 regions having positive numbers of Item 1) and 3 in the column of Item 2 (since there are 3 regions (Can, China, Japan) having positive numbers of item 2), right?

You are exactly right!