根据不同的像元值对像元值求和 [英] sum cell values depending to a diferent cell value
问题描述
你好,
我想在Excel电子表格中汇总一系列单元格值,但不是全部.我有2列,一列代表车号,一列代表金额,如何根据特定单元格中给出的车号求和特定金额的值?
例如. 1排车数1254钱1000、2排车数2562钱500、3排车数1254钱1000,我如何根据车数的价值将1和3排钱相加? (在这种情况下为1254).
我知道excel中有很多vb脚本,但是您能帮我吗?
谢谢
Kyriakos
Hello,
I want to sum a range of cell values in an excel spreadsheet but not all of them. I have 2 columns one for the car number and one for the amount of money, how can I sum specific values of the amount of money depending on the car number given in a certain cell?
eg. 1row car num 1254 money 1000, 2 row car num 2562 money 500, 3 row car num 1254 money 1000, how can I sum the 1 and 3 row money depending on the value of car num? (in this case 1254).
I know it is a lot of vb script in excel but can you help me?
Thank you
Kyriakos
推荐答案
使用 SUMIF [ ^ ] 公式 [ http://www.activexperts.com/activmonitor/windowsmanagement/scripts/msoffice/excel/ [^ ]
http://www.visualbasicscript.com/VBScript-amp-Excel-m32435.aspx [ ^ ]
http://mahimavbscript.blogspot.com/2010/09/working-with-excel- object.html [^ ]
http://itknowledgeexchange .techtarget.com/vbscript-systems-administrator/与excelapplication-object-in-vbscript-to-create-excel-spreadsheets/ [
Use SUMIF[^] formula[^].
More at:
http://www.activexperts.com/activmonitor/windowsmanagement/scripts/msoffice/excel/[^]
http://www.visualbasicscript.com/VBScript-amp-Excel-m32435.aspx[^]
http://mahimavbscript.blogspot.com/2010/09/working-with-excel-object.html[^]
http://itknowledgeexchange.techtarget.com/vbscript-systems-administrator/working-with-the-excelapplication-object-in-vbscript-to-create-excel-spreadsheets/[^]
这篇关于根据不同的像元值对像元值求和的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!