Countif Based On Another Column with filter In Excel
-1
I am trying to perform a countif, based on criteria from another column with a filter.
Goal: Count the number of times MD in Column A chose "5" in column B, despite it having a filter.
excel vba filter countif
edited Nov 16 '18 at 9:31
barbsan
2,54551524
asked Nov 16 '18 at 4:52
Erik ZometaErik Zometa
11
add a comment |
-1
I am trying to perform a countif, based on criteria from another column with a filter.
Goal: Count the number of times MD in Column A chose "5" in column B, despite it having a filter.
excel vba filter countif
edited Nov 16 '18 at 9:31
barbsan
2,54551524
asked Nov 16 '18 at 4:52
Erik ZometaErik Zometa
11
1
You have a vba tag, can you please post your code so we can help.
– alowflyingpig
Nov 16 '18 at 5:32
add a comment |
-1
-1
-1
I am trying to perform a countif, based on criteria from another column with a filter.
Goal: Count the number of times MD in Column A chose "5" in column B, despite it having a filter.
excel vba filter countif
edited Nov 16 '18 at 9:31
barbsan
2,54551524
asked Nov 16 '18 at 4:52
Erik ZometaErik Zometa
11
I am trying to perform a countif, based on criteria from another column with a filter.
Goal: Count the number of times MD in Column A chose "5" in column B, despite it having a filter.
excel vba filter countif
excel vba filter countif
edited Nov 16 '18 at 9:31
barbsan
2,54551524
asked Nov 16 '18 at 4:52
Erik ZometaErik Zometa
11
edited Nov 16 '18 at 9:31
barbsan
2,54551524
asked Nov 16 '18 at 4:52
Erik ZometaErik Zometa
11
edited Nov 16 '18 at 9:31
barbsan
2,54551524
edited Nov 16 '18 at 9:31
barbsan
2,54551524
edited Nov 16 '18 at 9:31
barbsan
2,54551524
2,54551524
asked Nov 16 '18 at 4:52
Erik ZometaErik Zometa
11
asked Nov 16 '18 at 4:52
Erik ZometaErik Zometa
11
asked Nov 16 '18 at 4:52
Erik ZometaErik Zometa
11
11
1
You have a vba tag, can you please post your code so we can help.
– alowflyingpig
Nov 16 '18 at 5:32
add a comment |
1
You have a vba tag, can you please post your code so we can help.
– alowflyingpig
Nov 16 '18 at 5:32
1
1
You have a vba tag, can you please post your code so we can help.
– alowflyingpig
Nov 16 '18 at 5:32
You have a vba tag, can you please post your code so we can help.
– alowflyingpig
Nov 16 '18 at 5:32
add a comment |
1 Answer
1
active
oldest
votes
0
Try this:
=countifs(b:b,a:a,"MD",b:b,5)
answered Nov 16 '18 at 5:41
Solar MikeSolar Mike
2,2992617
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
});
}
});
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%2f53331651%2fcountif-based-on-another-column-with-filter-in-excel%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
0
Try this:
=countifs(b:b,a:a,"MD",b:b,5)
answered Nov 16 '18 at 5:41
Solar MikeSolar Mike
2,2992617
add a comment |
0
Try this:
=countifs(b:b,a:a,"MD",b:b,5)
answered Nov 16 '18 at 5:41
Solar MikeSolar Mike
2,2992617
add a comment |
0
0
0
Try this:
=countifs(b:b,a:a,"MD",b:b,5)
answered Nov 16 '18 at 5:41
Solar MikeSolar Mike
2,2992617
Try this:
=countifs(b:b,a:a,"MD",b:b,5)
answered Nov 16 '18 at 5:41
Solar MikeSolar Mike
2,2992617
edited Nov 16 '18 at 5:48
answered Nov 16 '18 at 5:41
Solar MikeSolar Mike
2,2992617
answered Nov 16 '18 at 5:41
Solar MikeSolar Mike
2,2992617
answered Nov 16 '18 at 5:41
Solar MikeSolar Mike
2,2992617
2,2992617
add a comment |
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.
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%2f53331651%2fcountif-based-on-another-column-with-filter-in-excel%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
1
You have a vba tag, can you please post your code so we can help.
– alowflyingpig
Nov 16 '18 at 5:32