能否实现把有销售的品牌统计在一起?

100米跳远

看了附件很难受

红色的燕

原帖由 zhangjimfu 于 2011-1-3 10:36 发表
=IF(F9"",F3,"")&IF(G9"",G3,"")&IF(H9"",H3,"")&IF(I9"",I3,"")&IF(J9"",J3,"")&IF(K9"",K3,"")&IF(L9"",L3,"")&IF(M9"",M3,"")&IF(N9"",N3,"")&IF(O9"",O3,"")&IF(P9"",P3,"")&IF(Q9"",Q3,"")&IF(R9"",R3,"")&IF(S ...

我套用你的公式为什么没有文字表示而是一连串的数字呢?有时间的话,请帮我看看什么地方错了?谢谢哟!!

亡者天下

透视表不好用吗？

既方便又好理解

你不觉得吗？？

wuxiang_123

1. =IF(F4<>"",F$3,"")&IF(G4<>"",G$3,"")&IF(H4<>"",H$3,"")&IF(I4<>"",I$3,"")&IF(J4<>"",J$3,"")&IF(K4<>"",K$3,"")&IF(L4<>"",L$3,"")&IF(M4<>"",M$3,"")&IF(N4<>"",N$3,"")&IF(O4<>"",O$3,"")&IF(P4<>"",P$3,"")&IF(Q4<>"",Q$3,"")&IF(R4<>"",R$3,"")&IF(S4<>"",S$3,"")

复制代码

将9替换为4,将3替换为绝对引用$3

红色的燕

原帖由 wuxiang_123 于 2011-1-4 12:12 发表
=IF(F4"",F$3,"")&IF(G4"",G$3,"")&IF(H4"",H$3,"")&IF(I4"",I$3,"")&IF(J4"",J$3,"")&IF(K4"",K$3,"")&IF(L4"",L$3,"")&IF(M4"",M$3,"")&IF(N4"",N$3,"")&IF(O4"",O$3,"")&IF(P4"",P$3,"")&IF(Q4"",Q$3,"")&IF(R4"" ...

谢谢你了,因为昨天很忙,这正是我需要的!