宏将单元格值一起添加 [英] Macro to add cell values together

问题描述

嘿

我有一系列数据被分割，度量为1,2,3,4。 .etc和a，b，c等人。值的位置分为红色，琥珀色或绿色（在空白单元格中有 - 并且取决于目标1或所有RAG可能显示为
。

我需要合并数据（只需将它们加在一起），这样每个测量我只有1行。表1是原始数据，表2是我需要它的样子。

我试着写一个宏，在下面添加一行并执行= sum（）然后粘贴值并删除红色的琥珀色绿色，但有时我可能有红色的琥珀色和绿色而其他的只是红色，例如它没有工作。

表1

表2

提前致谢。

解决方案

表1

表2

Hey

I have a range of data that is split with the measure being 1,2,3,4..etc and the person being a,b,c...etc. the position of the value is split into Red, amber or green (with a - in the blank cell(s) and dependant on target 1 or all of the RAG could be displayed.

I need to combine the data (just adding them together)so that for each measure I only have 1 line. table 1 is the raw data and table 2 is how I need it to look.

I tried to write a macro adding a line below and doing an =sum() then paste values and delete the red amber green but as sometimes I could have red amber and green and others just red for example it didn't work.

Table 1

Table 2

Thanks in advance.

解决方案

Table 1

Table 2

这篇关于宏将单元格值一起添加的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！