Excel, how to count software choice per job type?
I have software use data for a bunch of different job types. Some people filled in multiple software packages.
My Excel sheet looks like this:
How do I get the amount of use for each software package per job type?
So for example:
3DS Max AutoCAD Bentley etc...
Architect 2 20 1
Consultant 3 15 3
etc...
Thanks!
microsoft-excel
add a comment |
I have software use data for a bunch of different job types. Some people filled in multiple software packages.
My Excel sheet looks like this:
How do I get the amount of use for each software package per job type?
So for example:
3DS Max AutoCAD Bentley etc...
Architect 2 20 1
Consultant 3 15 3
etc...
Thanks!
microsoft-excel
Is this in Excel or Google Sheets? You can use a Pivot Table in Excel to get this.
– BruceWayne
Feb 1 at 16:51
Google Sheets is off-topic here, on-topic on WebApps. It isn't identical to Excel in terms of features or how it handles things. Solutions for one won't necessarily work on the other, and people waste time trying to figure out why good solutions don't work. Post on the site that is appropriate for your application, and tag with just the correct application. Thanks.
– fixer1234
Feb 1 at 19:50
@fixer1234 I'll change my answer to just Excel to avoid confusion
– Gerlof Leuhof
Feb 2 at 17:04
add a comment |
I have software use data for a bunch of different job types. Some people filled in multiple software packages.
My Excel sheet looks like this:
How do I get the amount of use for each software package per job type?
So for example:
3DS Max AutoCAD Bentley etc...
Architect 2 20 1
Consultant 3 15 3
etc...
Thanks!
microsoft-excel
I have software use data for a bunch of different job types. Some people filled in multiple software packages.
My Excel sheet looks like this:
How do I get the amount of use for each software package per job type?
So for example:
3DS Max AutoCAD Bentley etc...
Architect 2 20 1
Consultant 3 15 3
etc...
Thanks!
microsoft-excel
microsoft-excel
edited Feb 2 at 17:14
fixer1234
18.8k144982
18.8k144982
asked Feb 1 at 12:56
Gerlof LeuhofGerlof Leuhof
1075
1075
Is this in Excel or Google Sheets? You can use a Pivot Table in Excel to get this.
– BruceWayne
Feb 1 at 16:51
Google Sheets is off-topic here, on-topic on WebApps. It isn't identical to Excel in terms of features or how it handles things. Solutions for one won't necessarily work on the other, and people waste time trying to figure out why good solutions don't work. Post on the site that is appropriate for your application, and tag with just the correct application. Thanks.
– fixer1234
Feb 1 at 19:50
@fixer1234 I'll change my answer to just Excel to avoid confusion
– Gerlof Leuhof
Feb 2 at 17:04
add a comment |
Is this in Excel or Google Sheets? You can use a Pivot Table in Excel to get this.
– BruceWayne
Feb 1 at 16:51
Google Sheets is off-topic here, on-topic on WebApps. It isn't identical to Excel in terms of features or how it handles things. Solutions for one won't necessarily work on the other, and people waste time trying to figure out why good solutions don't work. Post on the site that is appropriate for your application, and tag with just the correct application. Thanks.
– fixer1234
Feb 1 at 19:50
@fixer1234 I'll change my answer to just Excel to avoid confusion
– Gerlof Leuhof
Feb 2 at 17:04
Is this in Excel or Google Sheets? You can use a Pivot Table in Excel to get this.
– BruceWayne
Feb 1 at 16:51
Is this in Excel or Google Sheets? You can use a Pivot Table in Excel to get this.
– BruceWayne
Feb 1 at 16:51
Google Sheets is off-topic here, on-topic on WebApps. It isn't identical to Excel in terms of features or how it handles things. Solutions for one won't necessarily work on the other, and people waste time trying to figure out why good solutions don't work. Post on the site that is appropriate for your application, and tag with just the correct application. Thanks.
– fixer1234
Feb 1 at 19:50
Google Sheets is off-topic here, on-topic on WebApps. It isn't identical to Excel in terms of features or how it handles things. Solutions for one won't necessarily work on the other, and people waste time trying to figure out why good solutions don't work. Post on the site that is appropriate for your application, and tag with just the correct application. Thanks.
– fixer1234
Feb 1 at 19:50
@fixer1234 I'll change my answer to just Excel to avoid confusion
– Gerlof Leuhof
Feb 2 at 17:04
@fixer1234 I'll change my answer to just Excel to avoid confusion
– Gerlof Leuhof
Feb 2 at 17:04
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
});
}
});
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%2f1400978%2fexcel-how-to-count-software-choice-per-job-type%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
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%2f1400978%2fexcel-how-to-count-software-choice-per-job-type%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
Is this in Excel or Google Sheets? You can use a Pivot Table in Excel to get this.
– BruceWayne
Feb 1 at 16:51
Google Sheets is off-topic here, on-topic on WebApps. It isn't identical to Excel in terms of features or how it handles things. Solutions for one won't necessarily work on the other, and people waste time trying to figure out why good solutions don't work. Post on the site that is appropriate for your application, and tag with just the correct application. Thanks.
– fixer1234
Feb 1 at 19:50
@fixer1234 I'll change my answer to just Excel to avoid confusion
– Gerlof Leuhof
Feb 2 at 17:04