I have seen similar questions on here but still am confused. I have a large amount of data with a column for product number and sales amount. Is there away to sum the rows with the same product number? i have tried the match function but I am missing something. here is an example of what it looks like:
我在这里看到过类似的问题,但仍然感到困惑。我有大量数据,其中包含产品编号和销售额的列。是否有相同产品编号的行总和?我尝试过匹配功能,但我遗漏了一些东西。这是一个示例:
Product value (need a column here) 0012 12 0012 13 0113 3 0123 2 0123 23 etc. etc.
1 个解决方案
#1
0
To do this in Excel.
在Excel中执行此操作。
Assume that "Product" is in cell A1. You can use conditional summation. Type the following in C2
假设“Product”在单元格A1中。您可以使用条件求和。在C2中键入以下内容
=sumif($A$2:$A$10000, "="&$A2, $B$2:$B$10000)
The number 10000 is just a place holder for the end of the list.
数字10000只是列表末尾的占位符。
Copy this formula down the column of C, however far you want to go.
将此公式复制到C列,无论您想要走多远。
#1
0
To do this in Excel.
在Excel中执行此操作。
Assume that "Product" is in cell A1. You can use conditional summation. Type the following in C2
假设“Product”在单元格A1中。您可以使用条件求和。在C2中键入以下内容
=sumif($A$2:$A$10000, "="&$A2, $B$2:$B$10000)
The number 10000 is just a place holder for the end of the list.
数字10000只是列表末尾的占位符。
Copy this formula down the column of C, however far you want to go.
将此公式复制到C列,无论您想要走多远。