VBA Sumif vs Sumifs
up vote
0
down vote
favorite
UPDATE:
Thank you for your help thus far! That definitely worked.
I am wondering though if there is a way to add a loop function as well. What i would like it to do is to reference Column A of Worksheet 888 to identify the same value in Column A of 999, and sum the values in the last column of the sheet (keeping in mind that the last column may differ, thus allowing the macro to be more dynamic).
Dim LastRow, LastColumn As Long
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
LastColumn = Worksheets("888").Cells(1,
Columns.Count).End(xlToLeft).Column
For x= 1 To LastRow
Cells(x, 2).Value =
WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"),
Worksheets("999").Range("A:LastRow"),
Worksheets("888").Range("LastColumn:LastColumn"))
Next c
I keep getting the error "Unable to get the SumIf property of the worksheet function class. Any thoughts on how to fix?
excel vba excel-vba
asked Nov 9 at 2:15
VBAINPROGRESS
11
add a comment |
up vote
0
down vote
favorite
UPDATE:
Thank you for your help thus far! That definitely worked.
I am wondering though if there is a way to add a loop function as well. What i would like it to do is to reference Column A of Worksheet 888 to identify the same value in Column A of 999, and sum the values in the last column of the sheet (keeping in mind that the last column may differ, thus allowing the macro to be more dynamic).
Dim LastRow, LastColumn As Long
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
LastColumn = Worksheets("888").Cells(1,
Columns.Count).End(xlToLeft).Column
For x= 1 To LastRow
Cells(x, 2).Value =
WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"),
Worksheets("999").Range("A:LastRow"),
Worksheets("888").Range("LastColumn:LastColumn"))
Next c
I keep getting the error "Unable to get the SumIf property of the worksheet function class. Any thoughts on how to fix?
excel vba excel-vba
asked Nov 9 at 2:15
VBAINPROGRESS
11
Also, is SUMIFS a better option here? may add a bit more flexibility
– VBAINPROGRESS
Nov 9 at 2:16
see: exceljet.net/formula/3d-sumif-for-multiple-worksheets
– Scott Craner
Nov 9 at 2:18
Thanks Scott, very helpful. Is there a way that I could manipulate that formula into VBA as opposed to a macro? Additionally I am struggling to identify the correct criteria to include in the code; I originally input ("Sheet1").Cells("i:2") into the criteria segment of the SUMIF function, but I think i may have to reference a solitary cell or logical argument as opposed to a range of cells. Any thoughts there?
– VBAINPROGRESS
Nov 9 at 2:55
That definitely worked - I am wondering though if there is a way to add a loop function as well: Dim LastRow, LastColumn As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row LastColumn = Worksheets("888").Cells(1, Columns.Count).End(xlToLeft).Column For x= 1 To LastRow Cells(x, 2).Value = WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"), Worksheets("999").Range("A:LastRow"), Worksheets("888").Range("LastColumn:LastColumn")) Next c I keep getting the error "Unable to get the SumIf propery of the worksheet function class. Any thoughts on how to fix?
– VBAINPROGRESS
Nov 21 at 3:01
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
UPDATE:
Thank you for your help thus far! That definitely worked.
I am wondering though if there is a way to add a loop function as well. What i would like it to do is to reference Column A of Worksheet 888 to identify the same value in Column A of 999, and sum the values in the last column of the sheet (keeping in mind that the last column may differ, thus allowing the macro to be more dynamic).
Dim LastRow, LastColumn As Long
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
LastColumn = Worksheets("888").Cells(1,
Columns.Count).End(xlToLeft).Column
For x= 1 To LastRow
Cells(x, 2).Value =
WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"),
Worksheets("999").Range("A:LastRow"),
Worksheets("888").Range("LastColumn:LastColumn"))
Next c
I keep getting the error "Unable to get the SumIf property of the worksheet function class. Any thoughts on how to fix?
excel vba excel-vba
asked Nov 9 at 2:15
VBAINPROGRESS
11
UPDATE:
Thank you for your help thus far! That definitely worked.
I am wondering though if there is a way to add a loop function as well. What i would like it to do is to reference Column A of Worksheet 888 to identify the same value in Column A of 999, and sum the values in the last column of the sheet (keeping in mind that the last column may differ, thus allowing the macro to be more dynamic).
Dim LastRow, LastColumn As Long
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
LastColumn = Worksheets("888").Cells(1,
Columns.Count).End(xlToLeft).Column
For x= 1 To LastRow
Cells(x, 2).Value =
WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"),
Worksheets("999").Range("A:LastRow"),
Worksheets("888").Range("LastColumn:LastColumn"))
Next c
I keep getting the error "Unable to get the SumIf property of the worksheet function class. Any thoughts on how to fix?
excel vba excel-vba
excel vba excel-vba
asked Nov 9 at 2:15
VBAINPROGRESS
11
asked Nov 9 at 2:15
VBAINPROGRESS
11
edited Nov 21 at 23:53
asked Nov 9 at 2:15
VBAINPROGRESS
11
asked Nov 9 at 2:15
VBAINPROGRESS
11
asked Nov 9 at 2:15
VBAINPROGRESS
11
11
Also, is SUMIFS a better option here? may add a bit more flexibility
– VBAINPROGRESS
Nov 9 at 2:16
see: exceljet.net/formula/3d-sumif-for-multiple-worksheets
– Scott Craner
Nov 9 at 2:18
Thanks Scott, very helpful. Is there a way that I could manipulate that formula into VBA as opposed to a macro? Additionally I am struggling to identify the correct criteria to include in the code; I originally input ("Sheet1").Cells("i:2") into the criteria segment of the SUMIF function, but I think i may have to reference a solitary cell or logical argument as opposed to a range of cells. Any thoughts there?
– VBAINPROGRESS
Nov 9 at 2:55
That definitely worked - I am wondering though if there is a way to add a loop function as well: Dim LastRow, LastColumn As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row LastColumn = Worksheets("888").Cells(1, Columns.Count).End(xlToLeft).Column For x= 1 To LastRow Cells(x, 2).Value = WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"), Worksheets("999").Range("A:LastRow"), Worksheets("888").Range("LastColumn:LastColumn")) Next c I keep getting the error "Unable to get the SumIf propery of the worksheet function class. Any thoughts on how to fix?
– VBAINPROGRESS
Nov 21 at 3:01
add a comment |
Also, is SUMIFS a better option here? may add a bit more flexibility
– VBAINPROGRESS
Nov 9 at 2:16
see: exceljet.net/formula/3d-sumif-for-multiple-worksheets
– Scott Craner
Nov 9 at 2:18
Thanks Scott, very helpful. Is there a way that I could manipulate that formula into VBA as opposed to a macro? Additionally I am struggling to identify the correct criteria to include in the code; I originally input ("Sheet1").Cells("i:2") into the criteria segment of the SUMIF function, but I think i may have to reference a solitary cell or logical argument as opposed to a range of cells. Any thoughts there?
– VBAINPROGRESS
Nov 9 at 2:55
That definitely worked - I am wondering though if there is a way to add a loop function as well: Dim LastRow, LastColumn As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row LastColumn = Worksheets("888").Cells(1, Columns.Count).End(xlToLeft).Column For x= 1 To LastRow Cells(x, 2).Value = WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"), Worksheets("999").Range("A:LastRow"), Worksheets("888").Range("LastColumn:LastColumn")) Next c I keep getting the error "Unable to get the SumIf propery of the worksheet function class. Any thoughts on how to fix?
– VBAINPROGRESS
Nov 21 at 3:01
Also, is SUMIFS a better option here? may add a bit more flexibility
– VBAINPROGRESS
Nov 9 at 2:16
Also, is SUMIFS a better option here? may add a bit more flexibility
– VBAINPROGRESS
Nov 9 at 2:16
see: exceljet.net/formula/3d-sumif-for-multiple-worksheets
– Scott Craner
Nov 9 at 2:18
see: exceljet.net/formula/3d-sumif-for-multiple-worksheets
– Scott Craner
Nov 9 at 2:18
Thanks Scott, very helpful. Is there a way that I could manipulate that formula into VBA as opposed to a macro? Additionally I am struggling to identify the correct criteria to include in the code; I originally input ("Sheet1").Cells("i:2") into the criteria segment of the SUMIF function, but I think i may have to reference a solitary cell or logical argument as opposed to a range of cells. Any thoughts there?
– VBAINPROGRESS
Nov 9 at 2:55
Thanks Scott, very helpful. Is there a way that I could manipulate that formula into VBA as opposed to a macro? Additionally I am struggling to identify the correct criteria to include in the code; I originally input ("Sheet1").Cells("i:2") into the criteria segment of the SUMIF function, but I think i may have to reference a solitary cell or logical argument as opposed to a range of cells. Any thoughts there?
– VBAINPROGRESS
Nov 9 at 2:55
That definitely worked - I am wondering though if there is a way to add a loop function as well: Dim LastRow, LastColumn As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row LastColumn = Worksheets("888").Cells(1, Columns.Count).End(xlToLeft).Column For x= 1 To LastRow Cells(x, 2).Value = WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"), Worksheets("999").Range("A:LastRow"), Worksheets("888").Range("LastColumn:LastColumn")) Next c I keep getting the error "Unable to get the SumIf propery of the worksheet function class. Any thoughts on how to fix?
– VBAINPROGRESS
Nov 21 at 3:01
That definitely worked - I am wondering though if there is a way to add a loop function as well: Dim LastRow, LastColumn As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row LastColumn = Worksheets("888").Cells(1, Columns.Count).End(xlToLeft).Column For x= 1 To LastRow Cells(x, 2).Value = WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"), Worksheets("999").Range("A:LastRow"), Worksheets("888").Range("LastColumn:LastColumn")) Next c I keep getting the error "Unable to get the SumIf propery of the worksheet function class. Any thoughts on how to fix?
– VBAINPROGRESS
Nov 21 at 3:01
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
i don't really understand why do you want to use macro when formula can do the job
put below in C2 and drag down the formula should do the job
=SUMIF(Sheet2!F:F,A2,Sheet2!H:H)+SUMIF(Sheet3!J:J,A2,Sheet3!L:L)
but if you insist macro,
Worksheets("Sheet1").Range("C2").Value = "=SUMIF(Sheet2!F:F,A2,Sheet2!H:H)+SUMIF(Sheet3!J:J,A2,Sheet3!L:L)"
Worksheets("Sheet1").Range("C2:C7").FillDown
answered Nov 9 at 3:17
Osman Wong
1036
That definitely worked - Thanks! I am wondering though if there is a way to add a loop function as well: Dim LastRow, LastColumn As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row LastColumn = Worksheets("888").Cells(1, Columns.Count).End(xlToLeft).Column For x= 1 To LastRow Cells(x, 2).Value = WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"), Worksheets("999").Range("A:LastRow"), Worksheets("888").Range("LastColumn:LastColumn")) Next c I keep getting the error "Unable to get the SumIf propery of the worksheet function class. Any thoughts on how to fix?
– VBAINPROGRESS
Nov 21 at 3:52
try to amend your original post to add that code to make it more readable, but just by glance your issue is with "A:LastRow" "LastColumn:LastColumn" - they are variables so should not be in the semi-colan. remember last row/column is always in number not ABCDE
– Osman Wong
Nov 21 at 8:31
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53218902%2fvba-sumif-vs-sumifs%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
i don't really understand why do you want to use macro when formula can do the job
put below in C2 and drag down the formula should do the job
=SUMIF(Sheet2!F:F,A2,Sheet2!H:H)+SUMIF(Sheet3!J:J,A2,Sheet3!L:L)
but if you insist macro,
Worksheets("Sheet1").Range("C2").Value = "=SUMIF(Sheet2!F:F,A2,Sheet2!H:H)+SUMIF(Sheet3!J:J,A2,Sheet3!L:L)"
Worksheets("Sheet1").Range("C2:C7").FillDown
answered Nov 9 at 3:17
Osman Wong
1036
That definitely worked - Thanks! I am wondering though if there is a way to add a loop function as well: Dim LastRow, LastColumn As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row LastColumn = Worksheets("888").Cells(1, Columns.Count).End(xlToLeft).Column For x= 1 To LastRow Cells(x, 2).Value = WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"), Worksheets("999").Range("A:LastRow"), Worksheets("888").Range("LastColumn:LastColumn")) Next c I keep getting the error "Unable to get the SumIf propery of the worksheet function class. Any thoughts on how to fix?
– VBAINPROGRESS
Nov 21 at 3:52
try to amend your original post to add that code to make it more readable, but just by glance your issue is with "A:LastRow" "LastColumn:LastColumn" - they are variables so should not be in the semi-colan. remember last row/column is always in number not ABCDE
– Osman Wong
Nov 21 at 8:31
add a comment |
up vote
0
down vote
i don't really understand why do you want to use macro when formula can do the job
put below in C2 and drag down the formula should do the job
=SUMIF(Sheet2!F:F,A2,Sheet2!H:H)+SUMIF(Sheet3!J:J,A2,Sheet3!L:L)
but if you insist macro,
Worksheets("Sheet1").Range("C2").Value = "=SUMIF(Sheet2!F:F,A2,Sheet2!H:H)+SUMIF(Sheet3!J:J,A2,Sheet3!L:L)"
Worksheets("Sheet1").Range("C2:C7").FillDown
answered Nov 9 at 3:17
Osman Wong
1036
That definitely worked - Thanks! I am wondering though if there is a way to add a loop function as well: Dim LastRow, LastColumn As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row LastColumn = Worksheets("888").Cells(1, Columns.Count).End(xlToLeft).Column For x= 1 To LastRow Cells(x, 2).Value = WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"), Worksheets("999").Range("A:LastRow"), Worksheets("888").Range("LastColumn:LastColumn")) Next c I keep getting the error "Unable to get the SumIf propery of the worksheet function class. Any thoughts on how to fix?
– VBAINPROGRESS
Nov 21 at 3:52
try to amend your original post to add that code to make it more readable, but just by glance your issue is with "A:LastRow" "LastColumn:LastColumn" - they are variables so should not be in the semi-colan. remember last row/column is always in number not ABCDE
– Osman Wong
Nov 21 at 8:31
add a comment |
up vote
0
down vote
up vote
0
down vote
i don't really understand why do you want to use macro when formula can do the job
put below in C2 and drag down the formula should do the job
=SUMIF(Sheet2!F:F,A2,Sheet2!H:H)+SUMIF(Sheet3!J:J,A2,Sheet3!L:L)
but if you insist macro,
Worksheets("Sheet1").Range("C2").Value = "=SUMIF(Sheet2!F:F,A2,Sheet2!H:H)+SUMIF(Sheet3!J:J,A2,Sheet3!L:L)"
Worksheets("Sheet1").Range("C2:C7").FillDown
answered Nov 9 at 3:17
Osman Wong
1036
i don't really understand why do you want to use macro when formula can do the job
put below in C2 and drag down the formula should do the job
=SUMIF(Sheet2!F:F,A2,Sheet2!H:H)+SUMIF(Sheet3!J:J,A2,Sheet3!L:L)
but if you insist macro,
Worksheets("Sheet1").Range("C2").Value = "=SUMIF(Sheet2!F:F,A2,Sheet2!H:H)+SUMIF(Sheet3!J:J,A2,Sheet3!L:L)"
Worksheets("Sheet1").Range("C2:C7").FillDown
answered Nov 9 at 3:17
Osman Wong
1036
answered Nov 9 at 3:17
Osman Wong
1036
answered Nov 9 at 3:17
Osman Wong
1036
answered Nov 9 at 3:17
Osman Wong
1036
1036
That definitely worked - Thanks! I am wondering though if there is a way to add a loop function as well: Dim LastRow, LastColumn As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row LastColumn = Worksheets("888").Cells(1, Columns.Count).End(xlToLeft).Column For x= 1 To LastRow Cells(x, 2).Value = WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"), Worksheets("999").Range("A:LastRow"), Worksheets("888").Range("LastColumn:LastColumn")) Next c I keep getting the error "Unable to get the SumIf propery of the worksheet function class. Any thoughts on how to fix?
– VBAINPROGRESS
Nov 21 at 3:52
try to amend your original post to add that code to make it more readable, but just by glance your issue is with "A:LastRow" "LastColumn:LastColumn" - they are variables so should not be in the semi-colan. remember last row/column is always in number not ABCDE
– Osman Wong
Nov 21 at 8:31
add a comment |
That definitely worked - Thanks! I am wondering though if there is a way to add a loop function as well: Dim LastRow, LastColumn As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row LastColumn = Worksheets("888").Cells(1, Columns.Count).End(xlToLeft).Column For x= 1 To LastRow Cells(x, 2).Value = WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"), Worksheets("999").Range("A:LastRow"), Worksheets("888").Range("LastColumn:LastColumn")) Next c I keep getting the error "Unable to get the SumIf propery of the worksheet function class. Any thoughts on how to fix?
– VBAINPROGRESS
Nov 21 at 3:52
try to amend your original post to add that code to make it more readable, but just by glance your issue is with "A:LastRow" "LastColumn:LastColumn" - they are variables so should not be in the semi-colan. remember last row/column is always in number not ABCDE
– Osman Wong
Nov 21 at 8:31
That definitely worked - Thanks! I am wondering though if there is a way to add a loop function as well: Dim LastRow, LastColumn As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row LastColumn = Worksheets("888").Cells(1, Columns.Count).End(xlToLeft).Column For x= 1 To LastRow Cells(x, 2).Value = WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"), Worksheets("999").Range("A:LastRow"), Worksheets("888").Range("LastColumn:LastColumn")) Next c I keep getting the error "Unable to get the SumIf propery of the worksheet function class. Any thoughts on how to fix?
– VBAINPROGRESS
Nov 21 at 3:52
That definitely worked - Thanks! I am wondering though if there is a way to add a loop function as well: Dim LastRow, LastColumn As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row LastColumn = Worksheets("888").Cells(1, Columns.Count).End(xlToLeft).Column For x= 1 To LastRow Cells(x, 2).Value = WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"), Worksheets("999").Range("A:LastRow"), Worksheets("888").Range("LastColumn:LastColumn")) Next c I keep getting the error "Unable to get the SumIf propery of the worksheet function class. Any thoughts on how to fix?
– VBAINPROGRESS
Nov 21 at 3:52
try to amend your original post to add that code to make it more readable, but just by glance your issue is with "A:LastRow" "LastColumn:LastColumn" - they are variables so should not be in the semi-colan. remember last row/column is always in number not ABCDE
– Osman Wong
Nov 21 at 8:31
try to amend your original post to add that code to make it more readable, but just by glance your issue is with "A:LastRow" "LastColumn:LastColumn" - they are variables so should not be in the semi-colan. remember last row/column is always in number not ABCDE
– Osman Wong
Nov 21 at 8:31
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53218902%2fvba-sumif-vs-sumifs%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Also, is SUMIFS a better option here? may add a bit more flexibility
– VBAINPROGRESS
Nov 9 at 2:16
see: exceljet.net/formula/3d-sumif-for-multiple-worksheets
– Scott Craner
Nov 9 at 2:18
Thanks Scott, very helpful. Is there a way that I could manipulate that formula into VBA as opposed to a macro? Additionally I am struggling to identify the correct criteria to include in the code; I originally input ("Sheet1").Cells("i:2") into the criteria segment of the SUMIF function, but I think i may have to reference a solitary cell or logical argument as opposed to a range of cells. Any thoughts there?
– VBAINPROGRESS
Nov 9 at 2:55
That definitely worked - I am wondering though if there is a way to add a loop function as well: Dim LastRow, LastColumn As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row LastColumn = Worksheets("888").Cells(1, Columns.Count).End(xlToLeft).Column For x= 1 To LastRow Cells(x, 2).Value = WorksheetFunction.SumIf(Worksheets("888").Range("A:LastRow"), Worksheets("999").Range("A:LastRow"), Worksheets("888").Range("LastColumn:LastColumn")) Next c I keep getting the error "Unable to get the SumIf propery of the worksheet function class. Any thoughts on how to fix?
– VBAINPROGRESS
Nov 21 at 3:01