Excel: How to use =SUM() with two strings for range? The 2019 Stack Overflow Developer Survey...
Inversion Puzzle
Should I use my personal or workplace e-mail when registering to external websites for work purpose?
How to manage monthly salary
Should I write numbers in words or as numerals when there are multiple next to each other?
Is domain driven design an anti-SQL pattern?
How to deal with fear of taking dependencies
If a poisoned arrow's piercing damage is reduced to 0, do you still get poisoned?
Does it makes sense to buy a new cycle to learn riding?
How to make payment on the internet without leaving a money trail?
The difference between dialogue marks
What is the meaning of Triage in Cybersec world?
Is three citations per paragraph excessive for undergraduate research paper?
JSON.serialize: is it possible to suppress null values of a map?
Time travel alters history but people keep saying nothing's changed
What is the motivation for a law requiring 2 parties to consent for recording a conversation
What does "sndry explns" mean in one of the Hitchhiker's guide books?
Evaluating number of iteration with a certain map with While
Pristine Bit Checking
Spanish for "widget"
Can I write a for loop that iterates over both collections and arrays?
How to reverse every other sublist of a list?
On the insanity of kings as an argument against Monarchy
I see my dog run
Is it possible for the two major parties in the UK to form a coalition with each other instead of a much smaller party?
Excel: How to use =SUM() with two strings for range?
The 2019 Stack Overflow Developer Survey Results Are InExcel - Sum certain range from pivot tableComparing two strings in excel, add value for common variablesExcel: Referencing a named range inside a formulaHow to sum with two variables involving date rangeExtract number from complex string if it falls in a given rangeSUMIF - compare two columns of strings, sum related valuesHow to combine a range and cell into a new range within a formula in ExcelExcel, want to read a column and sum up the values that match in another columnTrue/False for two arrays having 1+ values that are the sameExtract certain words from strings of text in Excel cells
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I need to pass in two strings indicating the two locations of the range. However, SUM wouldn't read the string, but it reads the value of what's supposed to be the indicator of a location.
What I wrote:
=SUM(E20:E21)
The value of E20 is E4, and the value of E21 is E10. They are both dynamically generated. How can I get the actual sum from the location that the value of E20 indicates to the location that the value of E21 indicates?
microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2013 microsoft-excel-2016
edited 2 days ago
Máté Juhász
14.8k63552
asked 2 days ago
HykilpikonnaHykilpikonna
82
New contributor
Hykilpikonna 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 need to pass in two strings indicating the two locations of the range. However, SUM wouldn't read the string, but it reads the value of what's supposed to be the indicator of a location.
What I wrote:
=SUM(E20:E21)
The value of E20 is E4, and the value of E21 is E10. They are both dynamically generated. How can I get the actual sum from the location that the value of E20 indicates to the location that the value of E21 indicates?
microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2013 microsoft-excel-2016
edited 2 days ago
Máté Juhász
14.8k63552
asked 2 days ago
HykilpikonnaHykilpikonna
82
New contributor
Hykilpikonna is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Look intoINDIRECT
– cybernetic.nomad
2 days ago
add a comment |
I need to pass in two strings indicating the two locations of the range. However, SUM wouldn't read the string, but it reads the value of what's supposed to be the indicator of a location.
What I wrote:
=SUM(E20:E21)
The value of E20 is E4, and the value of E21 is E10. They are both dynamically generated. How can I get the actual sum from the location that the value of E20 indicates to the location that the value of E21 indicates?
microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2013 microsoft-excel-2016
edited 2 days ago
Máté Juhász
14.8k63552
asked 2 days ago
HykilpikonnaHykilpikonna
82
New contributor
Hykilpikonna is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I need to pass in two strings indicating the two locations of the range. However, SUM wouldn't read the string, but it reads the value of what's supposed to be the indicator of a location.
What I wrote:
=SUM(E20:E21)
The value of E20 is E4, and the value of E21 is E10. They are both dynamically generated. How can I get the actual sum from the location that the value of E20 indicates to the location that the value of E21 indicates?
microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2013 microsoft-excel-2016
microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2013 microsoft-excel-2016
edited 2 days ago
Máté Juhász
14.8k63552
asked 2 days ago
HykilpikonnaHykilpikonna
82
New contributor
Hykilpikonna is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 days ago
Máté Juhász
14.8k63552
asked 2 days ago
HykilpikonnaHykilpikonna
82
New contributor
Hykilpikonna is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 days ago
Máté Juhász
14.8k63552
edited 2 days ago
Máté Juhász
14.8k63552
edited 2 days ago
Máté Juhász
14.8k63552
14.8k63552
asked 2 days ago
HykilpikonnaHykilpikonna
82
New contributor
Hykilpikonna 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
HykilpikonnaHykilpikonna
82
asked 2 days ago
HykilpikonnaHykilpikonna
82
82
New contributor
Hykilpikonna is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Hykilpikonna is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Hykilpikonna is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Look intoINDIRECT
– cybernetic.nomad
2 days ago
add a comment |
Look intoINDIRECT
– cybernetic.nomad
2 days ago
Look into
INDIRECT– cybernetic.nomad
2 days ago
Look into
INDIRECT– cybernetic.nomad
2 days ago
add a comment |
1 Answer
1
active
oldest
votes
You can use INDIRECT:
=INDIRECT(E20&":"&E21)
answered 2 days ago
Máté JuhászMáté Juhász
14.8k63552
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
});
}
});
Hykilpikonna 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%2f1422601%2fexcel-how-to-use-sum-with-two-strings-for-range%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 INDIRECT:
=INDIRECT(E20&":"&E21)
answered 2 days ago
Máté JuhászMáté Juhász
14.8k63552
add a comment |
You can use INDIRECT:
=INDIRECT(E20&":"&E21)
answered 2 days ago
Máté JuhászMáté Juhász
14.8k63552
add a comment |
You can use INDIRECT:
=INDIRECT(E20&":"&E21)
answered 2 days ago
Máté JuhászMáté Juhász
14.8k63552
You can use INDIRECT:
=INDIRECT(E20&":"&E21)
answered 2 days ago
Máté JuhászMáté Juhász
14.8k63552
answered 2 days ago
Máté JuhászMáté Juhász
14.8k63552
answered 2 days ago
Máté JuhászMáté Juhász
14.8k63552
answered 2 days ago
Máté JuhászMáté Juhász
14.8k63552
14.8k63552
add a comment |
add a comment |
Hykilpikonna is a new contributor. Be nice, and check out our Code of Conduct.
Hykilpikonna is a new contributor. Be nice, and check out our Code of Conduct.
Hykilpikonna is a new contributor. Be nice, and check out our Code of Conduct.
Hykilpikonna 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%2f1422601%2fexcel-how-to-use-sum-with-two-strings-for-range%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
Look into
INDIRECT– cybernetic.nomad
2 days ago