I want to count two columns of data; the first column is a category, the second is a dateExcel - pivot table...
Simulate Bitwise Cyclic Tag
Why has Russell's definition of numbers using equivalence classes been finally abandoned? ( If it has actually been abandoned).
declaring a variable twice in IIFE
How can bays and straits be determined in a procedurally generated map?
How to type dʒ symbol (IPA) on Mac?
Download, install and reboot computer at night if needed
Are tax years 2016 & 2017 back taxes deductible for tax year 2018?
Why is "Reports" in sentence down without "The"
How can I fix this gap between bookcases I made?
The use of multiple foreign keys on same column in SQL Server
The magic money tree problem
Can I interfere when another PC is about to be attacked?
Prevent a directory in /tmp from being deleted
How is this relation reflexive?
How do I create uniquely male characters?
Extreme, but not acceptable situation and I can't start the work tomorrow morning
Can Medicine checks be used, with decent rolls, to completely mitigate the risk of death from ongoing damage?
Why is this code 6.5x slower with optimizations enabled?
What do you call a Matrix-like slowdown and camera movement effect?
least quadratic residue under GRH: an EXPLICIT bound
New order #4: World
Can town administrative "code" overule state laws like those forbidding trespassing?
Why is an old chain unsafe?
Concept of linear mappings are confusing me
I want to count two columns of data; the first column is a category, the second is a date
Excel - pivot table does not group datesAttempting to transpose two column table in excel using first column to group values in second columnIs there a way to match two time series covering same period but with different days missing?Display Show List when Value selected in CellExcel Sorting dilemaCount appearances of two-adjacent-cell value in range (Excel)Excel: COUNTIFS or Nested IF counting sequential columnsExcel 2016 Chart showing random dates in x axisMatch 2 dates in columns return 3rdExcel Match / Index - Fill in blank cells based on two other cells matching
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have two columns in my spreadsheet: Column A is a column of text (Chemical, Liquid, etc.) Column B is a column of dates. I would like to get a count of entries based first on the category, then by whether or not a date cell is filled in, ie., I want to know out of how many Chemicals in column A, have a date in column B. It doesn't matter what the date is, just that there is a date there (some will be blank).
microsoft-excel-2016 microsoft
asked 2 days ago
SueSue
1
New contributor
Sue is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have two columns in my spreadsheet: Column A is a column of text (Chemical, Liquid, etc.) Column B is a column of dates. I would like to get a count of entries based first on the category, then by whether or not a date cell is filled in, ie., I want to know out of how many Chemicals in column A, have a date in column B. It doesn't matter what the date is, just that there is a date there (some will be blank).
microsoft-excel-2016 microsoft
asked 2 days ago
SueSue
1
New contributor
Sue is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2
Welcome to Super User! So when you googled this question (or searched Super User's knowledge base) and started tryingCOUNTIFS, where did you run into trouble? How can we help you?
– Alex M
2 days ago
add a comment |
I have two columns in my spreadsheet: Column A is a column of text (Chemical, Liquid, etc.) Column B is a column of dates. I would like to get a count of entries based first on the category, then by whether or not a date cell is filled in, ie., I want to know out of how many Chemicals in column A, have a date in column B. It doesn't matter what the date is, just that there is a date there (some will be blank).
microsoft-excel-2016 microsoft
asked 2 days ago
SueSue
1
New contributor
Sue is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have two columns in my spreadsheet: Column A is a column of text (Chemical, Liquid, etc.) Column B is a column of dates. I would like to get a count of entries based first on the category, then by whether or not a date cell is filled in, ie., I want to know out of how many Chemicals in column A, have a date in column B. It doesn't matter what the date is, just that there is a date there (some will be blank).
microsoft-excel-2016 microsoft
microsoft-excel-2016 microsoft
asked 2 days ago
SueSue
1
New contributor
Sue is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 days ago
SueSue
1
New contributor
Sue is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 days ago
SueSue
1
New contributor
Sue is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 days ago
SueSue
1
asked 2 days ago
SueSue
1
1
New contributor
Sue is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Sue is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Sue is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2
Welcome to Super User! So when you googled this question (or searched Super User's knowledge base) and started tryingCOUNTIFS, where did you run into trouble? How can we help you?
– Alex M
2 days ago
add a comment |
2
Welcome to Super User! So when you googled this question (or searched Super User's knowledge base) and started tryingCOUNTIFS, where did you run into trouble? How can we help you?
– Alex M
2 days ago
2
2
Welcome to Super User! So when you googled this question (or searched Super User's knowledge base) and started trying
COUNTIFS, where did you run into trouble? How can we help you?– Alex M
2 days ago
Welcome to Super User! So when you googled this question (or searched Super User's knowledge base) and started trying
COUNTIFS, where did you run into trouble? How can we help you?– Alex M
2 days ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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
});
}
});
Sue is a new contributor. Be nice, and check out our Code of Conduct.
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%2fsuperuser.com%2fquestions%2f1421999%2fi-want-to-count-two-columns-of-data-the-first-column-is-a-category-the-second%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sue is a new contributor. Be nice, and check out our Code of Conduct.
Sue is a new contributor. Be nice, and check out our Code of Conduct.
Sue is a new contributor. Be nice, and check out our Code of Conduct.
Sue is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1421999%2fi-want-to-count-two-columns-of-data-the-first-column-is-a-category-the-second%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
2
Welcome to Super User! So when you googled this question (or searched Super User's knowledge base) and started trying
COUNTIFS, where did you run into trouble? How can we help you?– Alex M
2 days ago