VBA sumifs - ignore criteria if not found
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
Is there a way to create a sumifs function that ignores any criteria that aren't satisfied, and continues to sum based off of the other criteria?
Hope that makes sense...
excel vba excel-vba sumifs
edited Nov 16 '18 at 12:15
Pᴇʜ
25.1k63052
asked Nov 16 '18 at 11:49
JerbsJerbs
63
add a comment |
Is there a way to create a sumifs function that ignores any criteria that aren't satisfied, and continues to sum based off of the other criteria?
Hope that makes sense...
excel vba excel-vba sumifs
edited Nov 16 '18 at 12:15
Pᴇʜ
25.1k63052
asked Nov 16 '18 at 11:49
JerbsJerbs
63
I don't see any sense in ignoring a criteria that is not satisfied. Then you can just remove the criteria. If it is equal if the criteria is fulfilled or not then you don't need the criteria.
– Pᴇʜ
Nov 16 '18 at 12:17
add a comment |
Is there a way to create a sumifs function that ignores any criteria that aren't satisfied, and continues to sum based off of the other criteria?
Hope that makes sense...
excel vba excel-vba sumifs
edited Nov 16 '18 at 12:15
Pᴇʜ
25.1k63052
asked Nov 16 '18 at 11:49
JerbsJerbs
63
Is there a way to create a sumifs function that ignores any criteria that aren't satisfied, and continues to sum based off of the other criteria?
Hope that makes sense...
excel vba excel-vba sumifs
excel vba excel-vba sumifs
edited Nov 16 '18 at 12:15
Pᴇʜ
25.1k63052
asked Nov 16 '18 at 11:49
JerbsJerbs
63
edited Nov 16 '18 at 12:15
Pᴇʜ
25.1k63052
asked Nov 16 '18 at 11:49
JerbsJerbs
63
edited Nov 16 '18 at 12:15
Pᴇʜ
25.1k63052
edited Nov 16 '18 at 12:15
Pᴇʜ
25.1k63052
edited Nov 16 '18 at 12:15
Pᴇʜ
25.1k63052
25.1k63052
asked Nov 16 '18 at 11:49
JerbsJerbs
63
asked Nov 16 '18 at 11:49
JerbsJerbs
63
asked Nov 16 '18 at 11:49
JerbsJerbs
63
63
I don't see any sense in ignoring a criteria that is not satisfied. Then you can just remove the criteria. If it is equal if the criteria is fulfilled or not then you don't need the criteria.
– Pᴇʜ
Nov 16 '18 at 12:17
add a comment |
I don't see any sense in ignoring a criteria that is not satisfied. Then you can just remove the criteria. If it is equal if the criteria is fulfilled or not then you don't need the criteria.
– Pᴇʜ
Nov 16 '18 at 12:17
I don't see any sense in ignoring a criteria that is not satisfied. Then you can just remove the criteria. If it is equal if the criteria is fulfilled or not then you don't need the criteria.
– Pᴇʜ
Nov 16 '18 at 12:17
I don't see any sense in ignoring a criteria that is not satisfied. Then you can just remove the criteria. If it is equal if the criteria is fulfilled or not then you don't need the criteria.
– Pᴇʜ
Nov 16 '18 at 12:17
add a comment |
1 Answer
1
active
oldest
votes
Your question is a bit short..., but yes it is possible:
Put a countif on your Criteria and act when the result of the Countif = 0
=SUMIFS(C1:C6;A1:A6;IF(COUNTIF(A1:A6;H1)=0;"*";H1);B1:B6;1)
So when Criteria in H1 is not met this is replaced with * so it continues to the other criteria
answered Nov 16 '18 at 12:08
EvREvR
1,2612414
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',
autoActivateHeartbeat: false,
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
);
);
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%2f53337307%2fvba-sumifs-ignore-criteria-if-not-found%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
Your question is a bit short..., but yes it is possible:
Put a countif on your Criteria and act when the result of the Countif = 0
=SUMIFS(C1:C6;A1:A6;IF(COUNTIF(A1:A6;H1)=0;"*";H1);B1:B6;1)
So when Criteria in H1 is not met this is replaced with * so it continues to the other criteria
answered Nov 16 '18 at 12:08
EvREvR
1,2612414
add a comment |
Your question is a bit short..., but yes it is possible:
Put a countif on your Criteria and act when the result of the Countif = 0
=SUMIFS(C1:C6;A1:A6;IF(COUNTIF(A1:A6;H1)=0;"*";H1);B1:B6;1)
So when Criteria in H1 is not met this is replaced with * so it continues to the other criteria
answered Nov 16 '18 at 12:08
EvREvR
1,2612414
add a comment |
Your question is a bit short..., but yes it is possible:
Put a countif on your Criteria and act when the result of the Countif = 0
=SUMIFS(C1:C6;A1:A6;IF(COUNTIF(A1:A6;H1)=0;"*";H1);B1:B6;1)
So when Criteria in H1 is not met this is replaced with * so it continues to the other criteria
answered Nov 16 '18 at 12:08
EvREvR
1,2612414
Your question is a bit short..., but yes it is possible:
Put a countif on your Criteria and act when the result of the Countif = 0
=SUMIFS(C1:C6;A1:A6;IF(COUNTIF(A1:A6;H1)=0;"*";H1);B1:B6;1)
So when Criteria in H1 is not met this is replaced with * so it continues to the other criteria
answered Nov 16 '18 at 12:08
EvREvR
1,2612414
answered Nov 16 '18 at 12:08
EvREvR
1,2612414
answered Nov 16 '18 at 12:08
EvREvR
1,2612414
answered Nov 16 '18 at 12:08
EvREvR
1,2612414
1,2612414
add a comment |
add a comment |
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.
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%2f53337307%2fvba-sumifs-ignore-criteria-if-not-found%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
I don't see any sense in ignoring a criteria that is not satisfied. Then you can just remove the criteria. If it is equal if the criteria is fulfilled or not then you don't need the criteria.
– Pᴇʜ
Nov 16 '18 at 12:17