Find quantity sold of particular size over time
I have a spreadsheet where I am recording sales of shorts over time. I have been using it to keep a record of who buys them, what date, what size and how many pairs they bought. I'm hoping to expand this to start recording how many of each size have been sold over time.
This is an extract of what I have so far:
In column E, I have used =COUNTIF(A2:A11,"S") to count the number of sales of, for example, Small. This is working well. However, I am not at all sure what to put in the, 'By size: Qty,' column (column F from the screenshot).
Is there a formula that will check for all occurrences of a certain value and then check the values in the cells beside what it finds, totaling these values?
worksheet-function microsoft-excel-2013
edited Jan 3 at 11:12
DavidPostill♦
105k25227262
asked Jan 3 at 10:44
SYPOMarkSYPOMark
32
add a comment |
I have a spreadsheet where I am recording sales of shorts over time. I have been using it to keep a record of who buys them, what date, what size and how many pairs they bought. I'm hoping to expand this to start recording how many of each size have been sold over time.
This is an extract of what I have so far:
In column E, I have used =COUNTIF(A2:A11,"S") to count the number of sales of, for example, Small. This is working well. However, I am not at all sure what to put in the, 'By size: Qty,' column (column F from the screenshot).
Is there a formula that will check for all occurrences of a certain value and then check the values in the cells beside what it finds, totaling these values?
worksheet-function microsoft-excel-2013
edited Jan 3 at 11:12
DavidPostill♦
105k25227262
asked Jan 3 at 10:44
SYPOMarkSYPOMark
32
take a look atSUMIFexceljet.net/excel-functions/excel-sumif-function
– Andi Mohr
Jan 3 at 12:25
add a comment |
I have a spreadsheet where I am recording sales of shorts over time. I have been using it to keep a record of who buys them, what date, what size and how many pairs they bought. I'm hoping to expand this to start recording how many of each size have been sold over time.
This is an extract of what I have so far:
In column E, I have used =COUNTIF(A2:A11,"S") to count the number of sales of, for example, Small. This is working well. However, I am not at all sure what to put in the, 'By size: Qty,' column (column F from the screenshot).
Is there a formula that will check for all occurrences of a certain value and then check the values in the cells beside what it finds, totaling these values?
worksheet-function microsoft-excel-2013
edited Jan 3 at 11:12
DavidPostill♦
105k25227262
asked Jan 3 at 10:44
SYPOMarkSYPOMark
32
I have a spreadsheet where I am recording sales of shorts over time. I have been using it to keep a record of who buys them, what date, what size and how many pairs they bought. I'm hoping to expand this to start recording how many of each size have been sold over time.
This is an extract of what I have so far:
In column E, I have used =COUNTIF(A2:A11,"S") to count the number of sales of, for example, Small. This is working well. However, I am not at all sure what to put in the, 'By size: Qty,' column (column F from the screenshot).
Is there a formula that will check for all occurrences of a certain value and then check the values in the cells beside what it finds, totaling these values?
worksheet-function microsoft-excel-2013
worksheet-function microsoft-excel-2013
edited Jan 3 at 11:12
DavidPostill♦
105k25227262
asked Jan 3 at 10:44
SYPOMarkSYPOMark
32
edited Jan 3 at 11:12
DavidPostill♦
105k25227262
asked Jan 3 at 10:44
SYPOMarkSYPOMark
32
edited Jan 3 at 11:12
DavidPostill♦
105k25227262
edited Jan 3 at 11:12
DavidPostill♦
105k25227262
edited Jan 3 at 11:12
DavidPostill♦
105k25227262
105k25227262
asked Jan 3 at 10:44
SYPOMarkSYPOMark
32
asked Jan 3 at 10:44
SYPOMarkSYPOMark
32
asked Jan 3 at 10:44
SYPOMarkSYPOMark
32
32
take a look atSUMIFexceljet.net/excel-functions/excel-sumif-function
– Andi Mohr
Jan 3 at 12:25
add a comment |
take a look atSUMIFexceljet.net/excel-functions/excel-sumif-function
– Andi Mohr
Jan 3 at 12:25
take a look at
SUMIF exceljet.net/excel-functions/excel-sumif-function– Andi Mohr
Jan 3 at 12:25
take a look at
SUMIF exceljet.net/excel-functions/excel-sumif-function– Andi Mohr
Jan 3 at 12:25
add a comment |
1 Answer
1
active
oldest
votes
In column E you've used
=COUNTIF(A2:A11,"S")
To follow that up you want to use SUMIF in column F
=SUMIF(A2:A11, "S", B2:B11)
The way this works is it looks in column A to find rows that are "S" and then it sums the relevent values from column B.
answered Jan 3 at 12:33
RickyTillsonRickyTillson
32718
Hi @RickyTilson. Thanks for your helpful answer. It was just what I was after.
– SYPOMark
Jan 4 at 9:58
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%2f1390117%2ffind-quantity-sold-of-particular-size-over-time%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
In column E you've used
=COUNTIF(A2:A11,"S")
To follow that up you want to use SUMIF in column F
=SUMIF(A2:A11, "S", B2:B11)
The way this works is it looks in column A to find rows that are "S" and then it sums the relevent values from column B.
answered Jan 3 at 12:33
RickyTillsonRickyTillson
32718
Hi @RickyTilson. Thanks for your helpful answer. It was just what I was after.
– SYPOMark
Jan 4 at 9:58
add a comment |
In column E you've used
=COUNTIF(A2:A11,"S")
To follow that up you want to use SUMIF in column F
=SUMIF(A2:A11, "S", B2:B11)
The way this works is it looks in column A to find rows that are "S" and then it sums the relevent values from column B.
answered Jan 3 at 12:33
RickyTillsonRickyTillson
32718
Hi @RickyTilson. Thanks for your helpful answer. It was just what I was after.
– SYPOMark
Jan 4 at 9:58
add a comment |
In column E you've used
=COUNTIF(A2:A11,"S")
To follow that up you want to use SUMIF in column F
=SUMIF(A2:A11, "S", B2:B11)
The way this works is it looks in column A to find rows that are "S" and then it sums the relevent values from column B.
answered Jan 3 at 12:33
RickyTillsonRickyTillson
32718
In column E you've used
=COUNTIF(A2:A11,"S")
To follow that up you want to use SUMIF in column F
=SUMIF(A2:A11, "S", B2:B11)
The way this works is it looks in column A to find rows that are "S" and then it sums the relevent values from column B.
answered Jan 3 at 12:33
RickyTillsonRickyTillson
32718
answered Jan 3 at 12:33
RickyTillsonRickyTillson
32718
answered Jan 3 at 12:33
RickyTillsonRickyTillson
32718
answered Jan 3 at 12:33
RickyTillsonRickyTillson
32718
32718
Hi @RickyTilson. Thanks for your helpful answer. It was just what I was after.
– SYPOMark
Jan 4 at 9:58
add a comment |
Hi @RickyTilson. Thanks for your helpful answer. It was just what I was after.
– SYPOMark
Jan 4 at 9:58
Hi @RickyTilson. Thanks for your helpful answer. It was just what I was after.
– SYPOMark
Jan 4 at 9:58
Hi @RickyTilson. Thanks for your helpful answer. It was just what I was after.
– SYPOMark
Jan 4 at 9:58
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%2f1390117%2ffind-quantity-sold-of-particular-size-over-time%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
take a look at
SUMIFexceljet.net/excel-functions/excel-sumif-function– Andi Mohr
Jan 3 at 12:25