分离这些不同的名称从列然后总结那里的值VBA Excel [英] Separating These various names From column then summing there value VBA Excel

问题描述

我想总结一个人的全部价值。我想按名称提取行....在VBA中...名称永远不会改变，但名称的数量会发生变化。我想通过vba按名称来总结这些值。并将值放入数组中。说H7：N7谢谢先进.... Eric maxfield

I would like to sum a persons entire value . I would like to extract the rows by name .... In VBA ... THE names never change but the number of names change . I would like to sum these values by name via vba . And put there values into a Array . Say "H7: N7" Thank you in advanced .... Eric maxfield

Name  	Hours 	Time	Commission			
Aric 0	50	28	1431.6			
Aric 0	36	8	309.1			
Aric 0	15	7	113.9			
Aric 0	21.0	7.0	154.1			
Aric 0	12.0	2.0	38.5			
Eric 0			28.4			
Eric 1			14.7			
Eric 2			10.5		 
Eric 3			19.3			
Eric 4			6.8			
Ronnie 0		12.4			
Ronnie 0		11.9			
Ronnie 1		13.2			
Ralph 2			8.5			
Ralph 3			5.7			
Harry 0			15.0			
Harry 1			13.0			
Harry 2			16.0			
Harry 3			5.0			
Vallerie		12.0			
Vallerie		14.0			
Vallerie		11.0			
Vallerie		29.0			
Vallerie		15.0			

推荐答案

为什么要使用VBA，如果可以的话使用Excel工作表 SUMIF（） [ ^ ]功能或数据透视表 [ ^ ]？



但是如果你还想使用VBA，我建议你阅读这篇文章：如何使用VBA创建数据透视表 [ ^ ]

Why to use VBA, if it's possible to use Excel sheet SUMIF()[^] function or Pivot table[^]?

But if you still want to use VBA, i would recommend you to read this article: How to create Pivot table using VBA[^]

这篇关于分离这些不同的名称从列然后总结那里的值VBA Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！