Excel 2000函数问题 [英] Excel 2000 Function problem
问题描述
我编写了以下函数来汇总列中的值,其中我创建的范围的第5列和第6列中的值(称为lori)等于另一个摘要选项卡上的值(详细信息更低) *)
函数StCashTotalGBP(托管,实体)
计数器= 1:StCashTotalGBP = 0
Do While Counter< = Range(" lori")。Rows.Count
If Range(" lori")。Item(Counter,5)<>管理然后GoTo NextRow
如果范围(lori)。项目(计数器,6)<>实体然后GoTo NextRow
StCashTotalGBP = StCashTotalGBP + Range(lori)。Item(Counter,80):GoTo NextRow
NextRow :Counter = Counter + 1
循环
结束功能
我使用这个公式摘要标签
= StCashTotalGBP(E10,D10)
E10提供托管报告值(在lori范围的第5列中)和D10提供实体值。 (在lori范围的第6列中)
当我输入此公式时,我得到#NAME?错误。我知道Managed和entity的组合存在于范围内 - 那么为什么这不起作用?!
是因为我需要指定此范围是在另一个选项卡上摘要标签? (注意,该功能保存在此工作簿级别
任何帮助非常感谢!
I have written the following function to total up the values in a column where the values in columns 5 and 6 of a range I have created (called "lori") are equal to the values on another summary tab (details lower down)
Function StCashTotalGBP(Managed, Entity)
Counter = 1: StCashTotalGBP = 0
Do While Counter <= Range("lori").Rows.Count
If Range("lori").Item(Counter, 5) <> Managed Then GoTo NextRow
If Range("lori").Item(Counter, 6) <> Entity Then GoTo NextRow
StCashTotalGBP = StCashTotalGBP + Range("lori").Item(Counter, 80): GoTo NextRow
NextRow: Counter = Counter + 1
Loop
End Function
I use this formula on the summary tab
=StCashTotalGBP(E10, D10)
E10 provides the "managed" value (which is in column 5 of the "lori" range) and D10 provides the "entity value " (which is in column 6 of the "lori" range)
When I enter this formula I get the #NAME? error. I know that the combination of Managed and entity exists in the range - so why is this not working?!
Is it because I need to specify that this range is on another tab to the summary tab? (NB the function is held at the This workbook level
Any help greatly appreciated!
推荐答案
请问是否可以在BYTES中附加一个XLS文件的例子?
也许它不是代码而是你的数据格式。
我们更容易检测到错误而不是猜测什么是错误。
Please is it possible to attach in BYTES an example of the XLS file?
Maybe its not the code but the format of Your data.
Its much easier for Us to detect the error than guessing what can be wrong.
只是试图附加它 - 它说它是一个无效的文件 - 它的大小是3MB可能是问题?
Just tried to attach it - it says it is an invalid file - It''s 3MB in size is that likely to be the issue?
字节只允许附加一些类型(GIF,BMP,...)
请参阅附件窗口中的列表。
你可以仅在最大5Mb的ZIP文件中附加Excel文件。
Bytes let only some types to be attached (GIF, BMP, ...)
See list in attachment window.
You can only attach Excel file in ZIP files with max 5Mb.
这篇关于Excel 2000函数问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!