Conditional formula based on cell value Announcing the arrival of Valued Associate #679: Cesar...
What to do with someone that cheated their way though university and a PhD program?
TV series episode where humans nuke aliens before decrypting their message that states they come in peace
Why would the Overseers waste their stock of slaves on the Game?
Did war bonds have better investment alternatives during WWII?
Preserving file and folder permissions with rsync
How can I wire a 9-position switch so that each position turns on one more LED than the one before?
Is there a verb for listening stealthily?
What is /etc/mtab in Linux?
Is Bran literally the world's memory?
Israeli soda type drink
Will temporary Dex penalties prevent you from getting the benefits of the "Two Weapon Fighting" feat if your Dex score falls below the prerequisite?
`FindRoot [ ]`::jsing: Encountered a singular Jacobian at a point...WHY
Will I lose my paid in full property
Is it OK if I do not take the receipt in Germany?
Coin Game with infinite paradox
How would it unbalance gameplay to rule that Weapon Master allows for picking a fighting style?
What's the difference between using dependency injection with a container and using a service locator?
Does using the Inspiration rules for character defects encourage My Guy Syndrome?
Why is arima in R one time step off?
Variable does not exist: sObjectType (Task.sObjectType)
What is a 'Key' in computer science?
What were wait-states, and why was it only an issue for PCs?
How did Elite on the NES work?
/bin/ls sorts differently than just ls
Conditional formula based on cell value
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30 pm US/Eastern)Excel 2007 conditional formatting formula problemHow to edit a formula that I already have to take into account another cell's dataHow to specify dynamic tab in a sumifs formulaHow do I get this formula to respond with a calculation or text from cell?Conditional Formatting not working with formulaExcel 2013 formula for Missing DataExcel - Assigning unique numbers based on last valuePulling subset of data from Master sheet to individual sheets based on criteria, without using VBAHow to grab Excel value based on first iteration of another value?How do I copy formula across columns and rows, adjusting cell references and sheet names
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I am trying to create a simple Excel sheet to track customer debt. I have created a sheet called Customers and in there I have a list of customers.
Then for each month of the year, I have another sheet, e.g. April, May ...etc. April looks like this right now:
Inside the Remaining Debt cell for each customer, let's pick the first cell, so D2, I would like a formula that looks at the customer name A2, and if the customer name matches what's in April!B2 then the amount should be added.
The formula needs to work for all entries in the April sheet. To be honest, I am not sure if that is the best way to go about this, but I know this is one way.
If the formula is correct, the Remaining Debt cell will have -£1100. In terms of math formula, I think this will work:
debt amount + (all customer A activity in April and all other months)
I'm not sure how that translates to Excel.
microsoft-excel
asked 10 hours ago
J86J86
172211
add a comment |
I am trying to create a simple Excel sheet to track customer debt. I have created a sheet called Customers and in there I have a list of customers.
Then for each month of the year, I have another sheet, e.g. April, May ...etc. April looks like this right now:
Inside the Remaining Debt cell for each customer, let's pick the first cell, so D2, I would like a formula that looks at the customer name A2, and if the customer name matches what's in April!B2 then the amount should be added.
The formula needs to work for all entries in the April sheet. To be honest, I am not sure if that is the best way to go about this, but I know this is one way.
If the formula is correct, the Remaining Debt cell will have -£1100. In terms of math formula, I think this will work:
debt amount + (all customer A activity in April and all other months)
I'm not sure how that translates to Excel.
microsoft-excel
asked 10 hours ago
J86J86
172211
add a comment |
I am trying to create a simple Excel sheet to track customer debt. I have created a sheet called Customers and in there I have a list of customers.
Then for each month of the year, I have another sheet, e.g. April, May ...etc. April looks like this right now:
Inside the Remaining Debt cell for each customer, let's pick the first cell, so D2, I would like a formula that looks at the customer name A2, and if the customer name matches what's in April!B2 then the amount should be added.
The formula needs to work for all entries in the April sheet. To be honest, I am not sure if that is the best way to go about this, but I know this is one way.
If the formula is correct, the Remaining Debt cell will have -£1100. In terms of math formula, I think this will work:
debt amount + (all customer A activity in April and all other months)
I'm not sure how that translates to Excel.
microsoft-excel
asked 10 hours ago
J86J86
172211
I am trying to create a simple Excel sheet to track customer debt. I have created a sheet called Customers and in there I have a list of customers.
Then for each month of the year, I have another sheet, e.g. April, May ...etc. April looks like this right now:
Inside the Remaining Debt cell for each customer, let's pick the first cell, so D2, I would like a formula that looks at the customer name A2, and if the customer name matches what's in April!B2 then the amount should be added.
The formula needs to work for all entries in the April sheet. To be honest, I am not sure if that is the best way to go about this, but I know this is one way.
If the formula is correct, the Remaining Debt cell will have -£1100. In terms of math formula, I think this will work:
debt amount + (all customer A activity in April and all other months)
I'm not sure how that translates to Excel.
microsoft-excel
microsoft-excel
asked 10 hours ago
J86J86
172211
asked 10 hours ago
J86J86
172211
asked 10 hours ago
J86J86
172211
asked 10 hours ago
J86J86
172211
asked 10 hours ago
J86J86
172211
172211
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You can use a SUMIF for this. In D2 enter:
=C2+SUMIF(April!B:B,B2,April!D:D)
And populate down
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,842617
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%2f1428686%2fconditional-formula-based-on-cell-value%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
You can use a SUMIF for this. In D2 enter:
=C2+SUMIF(April!B:B,B2,April!D:D)
And populate down
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,842617
add a comment |
You can use a SUMIF for this. In D2 enter:
=C2+SUMIF(April!B:B,B2,April!D:D)
And populate down
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,842617
add a comment |
You can use a SUMIF for this. In D2 enter:
=C2+SUMIF(April!B:B,B2,April!D:D)
And populate down
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,842617
You can use a SUMIF for this. In D2 enter:
=C2+SUMIF(April!B:B,B2,April!D:D)
And populate down
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,842617
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,842617
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,842617
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,842617
2,842617
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%2f1428686%2fconditional-formula-based-on-cell-value%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
