Excel: organizing identified variables in their own table
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I'm not trying to get super complicated with this but I'm struggling with the logic. I'm trying to organize my day-to-day time; in minutes; in three groups.
- Direct,
- Indirect,
- and Other.
I already have it set up that I type D,I, or O as I'm entering in my information so that my quick and dirty activity log goes as follows
Activity. | Type. | Start time. | End time. | Minutes.
I already know how to find the difference in time in mind minutes. I'm struggling on how to organize the type in a separate graph to track how many minutes of my day are direct, indirect, or other. I guess an IF function but I'm unsure how to write the logic. Haven't found success from that though.
worksheet-function microsoft-excel-2016
edited Feb 7 at 1:02
angelofdev
929120
asked Feb 6 at 23:15
user995086user995086
61
add a comment |
I'm not trying to get super complicated with this but I'm struggling with the logic. I'm trying to organize my day-to-day time; in minutes; in three groups.
- Direct,
- Indirect,
- and Other.
I already have it set up that I type D,I, or O as I'm entering in my information so that my quick and dirty activity log goes as follows
Activity. | Type. | Start time. | End time. | Minutes.
I already know how to find the difference in time in mind minutes. I'm struggling on how to organize the type in a separate graph to track how many minutes of my day are direct, indirect, or other. I guess an IF function but I'm unsure how to write the logic. Haven't found success from that though.
worksheet-function microsoft-excel-2016
edited Feb 7 at 1:02
angelofdev
929120
asked Feb 6 at 23:15
user995086user995086
61
1
Your question is unclear in what you want to achieve but to point you into the correct direction you can try the SUMIF function.=SUMIF(range,criteria,sum_range). In your case your range is the Type, criteria is eitherD,IorO, sum_range is the entire Minutes column. Please think of what you exactly want to achieve (maybe provide an example output) and edit your question to notify people watching this question to get a suitable answer.
– angelofdev
Feb 7 at 0:33
add a comment |
I'm not trying to get super complicated with this but I'm struggling with the logic. I'm trying to organize my day-to-day time; in minutes; in three groups.
- Direct,
- Indirect,
- and Other.
I already have it set up that I type D,I, or O as I'm entering in my information so that my quick and dirty activity log goes as follows
Activity. | Type. | Start time. | End time. | Minutes.
I already know how to find the difference in time in mind minutes. I'm struggling on how to organize the type in a separate graph to track how many minutes of my day are direct, indirect, or other. I guess an IF function but I'm unsure how to write the logic. Haven't found success from that though.
worksheet-function microsoft-excel-2016
edited Feb 7 at 1:02
angelofdev
929120
asked Feb 6 at 23:15
user995086user995086
61
I'm not trying to get super complicated with this but I'm struggling with the logic. I'm trying to organize my day-to-day time; in minutes; in three groups.
- Direct,
- Indirect,
- and Other.
I already have it set up that I type D,I, or O as I'm entering in my information so that my quick and dirty activity log goes as follows
Activity. | Type. | Start time. | End time. | Minutes.
I already know how to find the difference in time in mind minutes. I'm struggling on how to organize the type in a separate graph to track how many minutes of my day are direct, indirect, or other. I guess an IF function but I'm unsure how to write the logic. Haven't found success from that though.
worksheet-function microsoft-excel-2016
worksheet-function microsoft-excel-2016
edited Feb 7 at 1:02
angelofdev
929120
asked Feb 6 at 23:15
user995086user995086
61
edited Feb 7 at 1:02
angelofdev
929120
asked Feb 6 at 23:15
user995086user995086
61
edited Feb 7 at 1:02
angelofdev
929120
edited Feb 7 at 1:02
angelofdev
929120
edited Feb 7 at 1:02
angelofdev
929120
929120
asked Feb 6 at 23:15
user995086user995086
61
asked Feb 6 at 23:15
user995086user995086
61
asked Feb 6 at 23:15
user995086user995086
61
61
1
Your question is unclear in what you want to achieve but to point you into the correct direction you can try the SUMIF function.=SUMIF(range,criteria,sum_range). In your case your range is the Type, criteria is eitherD,IorO, sum_range is the entire Minutes column. Please think of what you exactly want to achieve (maybe provide an example output) and edit your question to notify people watching this question to get a suitable answer.
– angelofdev
Feb 7 at 0:33
add a comment |
1
Your question is unclear in what you want to achieve but to point you into the correct direction you can try the SUMIF function.=SUMIF(range,criteria,sum_range). In your case your range is the Type, criteria is eitherD,IorO, sum_range is the entire Minutes column. Please think of what you exactly want to achieve (maybe provide an example output) and edit your question to notify people watching this question to get a suitable answer.
– angelofdev
Feb 7 at 0:33
1
1
Your question is unclear in what you want to achieve but to point you into the correct direction you can try the SUMIF function.
=SUMIF(range,criteria,sum_range). In your case your range is the Type, criteria is either D,I or O, sum_range is the entire Minutes column. Please think of what you exactly want to achieve (maybe provide an example output) and edit your question to notify people watching this question to get a suitable answer.– angelofdev
Feb 7 at 0:33
Your question is unclear in what you want to achieve but to point you into the correct direction you can try the SUMIF function.
=SUMIF(range,criteria,sum_range). In your case your range is the Type, criteria is either D,I or O, sum_range is the entire Minutes column. Please think of what you exactly want to achieve (maybe provide an example output) and edit your question to notify people watching this question to get a suitable answer.– angelofdev
Feb 7 at 0:33
add a comment |
1 Answer
1
active
oldest
votes
Formula is:
=SUMIF(B2:B7, "Put D, I or O here", E2:E7) (where column B is the type and column E is the minutes)
answered Feb 7 at 18:00
Geza KerecsenyiGeza Kerecsenyi
1799
add a comment |
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
});
}
});
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%2f1402904%2fexcel-organizing-identified-variables-in-their-own-table%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
Formula is:
=SUMIF(B2:B7, "Put D, I or O here", E2:E7) (where column B is the type and column E is the minutes)
answered Feb 7 at 18:00
Geza KerecsenyiGeza Kerecsenyi
1799
add a comment |
Formula is:
=SUMIF(B2:B7, "Put D, I or O here", E2:E7) (where column B is the type and column E is the minutes)
answered Feb 7 at 18:00
Geza KerecsenyiGeza Kerecsenyi
1799
add a comment |
Formula is:
=SUMIF(B2:B7, "Put D, I or O here", E2:E7) (where column B is the type and column E is the minutes)
answered Feb 7 at 18:00
Geza KerecsenyiGeza Kerecsenyi
1799
Formula is:
=SUMIF(B2:B7, "Put D, I or O here", E2:E7) (where column B is the type and column E is the minutes)
answered Feb 7 at 18:00
Geza KerecsenyiGeza Kerecsenyi
1799
answered Feb 7 at 18:00
Geza KerecsenyiGeza Kerecsenyi
1799
answered Feb 7 at 18:00
Geza KerecsenyiGeza Kerecsenyi
1799
answered Feb 7 at 18:00
Geza KerecsenyiGeza Kerecsenyi
1799
1799
add a comment |
add a comment |
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%2f1402904%2fexcel-organizing-identified-variables-in-their-own-table%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
Your question is unclear in what you want to achieve but to point you into the correct direction you can try the SUMIF function.
=SUMIF(range,criteria,sum_range). In your case your range is the Type, criteria is eitherD,IorO, sum_range is the entire Minutes column. Please think of what you exactly want to achieve (maybe provide an example output) and edit your question to notify people watching this question to get a suitable answer.– angelofdev
Feb 7 at 0:33