Series Ignoring Hidden RowsHow to make an Excel formula which totals several adjacent rows based on cell...
Could a warlock use the One with Shadows warlock invocation to turn invisible, and then move while staying invisible?
Potential client has a problematic employee I can't work with
Coworker asking me to not bring cakes due to self control issue. What should I do?
What to do with threats of blacklisting?
Custom shape shows unwanted extra line
Taking headphones when quitting job
Will rerolling initiative each round stop meta-gaming about initiative?
Why didn't Tom Riddle take the presence of Fawkes and the Sorting Hat as more of a threat?
Does it take energy to move something in a circle?
Which RAF squadrons and aircraft types took part in the bombing of Berlin on the 25th of August 1940?
How to politely refuse in-office gym instructor for steroids and protein
Has any human ever had the choice to leave Earth permanently?
Non-Cancer terminal illness that can affect young (age 10-13) girls?
Does the US government have any planning in place to ensure there's no shortages of food, fuel, steel and other commodities?
Equivalent of "illegal" for violating civil law
How can the probability of a fumble decrease linearly with more dice?
Is Screenshot Time-tracking Common?
Is `Object` a function in javascript?
Broad Strokes - missing letter riddle
How does Leonard in "Memento" remember reading and writing?
In harmony: key or the flow?
Eww, those bytes are gross
What can I do to encourage my players to use their consumables?
How do you get out of your own psychology to write characters?
Series Ignoring Hidden Rows
How to make an Excel formula which totals several adjacent rows based on cell valuesHow do I count # of rows in an array ONLY IF the sum of numbers for each row is >0 in Excel?Excel-Count number of visible cells containing certain stringDisplay empty cell if referencing empty cell (formula)Logic filtering of data in Excel between two columnsSumming a set of cells that appears after every x amount of rowsHow do I autofill formulas horizontally in excelError with Excel IF formatting, My function isn't workingHow can I Filtering and rename without renaming the unfiltered cells?Array Function Only Return First Value
I have tried using the SUBTOTAL function to do what I want, but it isn't working the way I want it to.
Here, it appears the formula is working perfectly with the filter still on.
Here, however, the formula did not do as I want, and instead just the values that would be in the blank cells.
Note, I am very new to Excel so this may be just a simple oversight on my part.
I used the formula =SUBTOTAL(103,$S$1:S1) and then just filled that into all the cells while in the filtered mode. How do I get this to work?
worksheet-function microsoft-excel-2010
edited 5 hours ago
angelofdev
928120
asked 5 hours ago
JollyJolly
1
New contributor
Jolly 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 have tried using the SUBTOTAL function to do what I want, but it isn't working the way I want it to.
Here, it appears the formula is working perfectly with the filter still on.
Here, however, the formula did not do as I want, and instead just the values that would be in the blank cells.
Note, I am very new to Excel so this may be just a simple oversight on my part.
I used the formula =SUBTOTAL(103,$S$1:S1) and then just filled that into all the cells while in the filtered mode. How do I get this to work?
worksheet-function microsoft-excel-2010
edited 5 hours ago
angelofdev
928120
asked 5 hours ago
JollyJolly
1
New contributor
Jolly 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 have tried using the SUBTOTAL function to do what I want, but it isn't working the way I want it to.
Here, it appears the formula is working perfectly with the filter still on.
Here, however, the formula did not do as I want, and instead just the values that would be in the blank cells.
Note, I am very new to Excel so this may be just a simple oversight on my part.
I used the formula =SUBTOTAL(103,$S$1:S1) and then just filled that into all the cells while in the filtered mode. How do I get this to work?
worksheet-function microsoft-excel-2010
edited 5 hours ago
angelofdev
928120
asked 5 hours ago
JollyJolly
1
New contributor
Jolly is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have tried using the SUBTOTAL function to do what I want, but it isn't working the way I want it to.
Here, it appears the formula is working perfectly with the filter still on.
Here, however, the formula did not do as I want, and instead just the values that would be in the blank cells.
Note, I am very new to Excel so this may be just a simple oversight on my part.
I used the formula =SUBTOTAL(103,$S$1:S1) and then just filled that into all the cells while in the filtered mode. How do I get this to work?
worksheet-function microsoft-excel-2010
worksheet-function microsoft-excel-2010
edited 5 hours ago
angelofdev
928120
asked 5 hours ago
JollyJolly
1
New contributor
Jolly is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 5 hours ago
angelofdev
928120
asked 5 hours ago
JollyJolly
1
New contributor
Jolly is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 5 hours ago
angelofdev
928120
edited 5 hours ago
angelofdev
928120
edited 5 hours ago
angelofdev
928120
928120
asked 5 hours ago
JollyJolly
1
New contributor
Jolly is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 hours ago
JollyJolly
1
asked 5 hours ago
JollyJolly
1
1
New contributor
Jolly is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Jolly is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Jolly 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 |
add a comment |
1 Answer
1
active
oldest
votes
Try applying the formula to all desired rows on the unfiltered data. It looks like you left out a few rows, because there are cells with no formula or result in column U. The principle works, if applied properly.
answered 5 hours ago
teylynteylyn
17.3k22539
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
});
}
});
Jolly 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%2f1409392%2fseries-ignoring-hidden-rows%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
Try applying the formula to all desired rows on the unfiltered data. It looks like you left out a few rows, because there are cells with no formula or result in column U. The principle works, if applied properly.
answered 5 hours ago
teylynteylyn
17.3k22539
add a comment |
Try applying the formula to all desired rows on the unfiltered data. It looks like you left out a few rows, because there are cells with no formula or result in column U. The principle works, if applied properly.
answered 5 hours ago
teylynteylyn
17.3k22539
add a comment |
Try applying the formula to all desired rows on the unfiltered data. It looks like you left out a few rows, because there are cells with no formula or result in column U. The principle works, if applied properly.
answered 5 hours ago
teylynteylyn
17.3k22539
Try applying the formula to all desired rows on the unfiltered data. It looks like you left out a few rows, because there are cells with no formula or result in column U. The principle works, if applied properly.
answered 5 hours ago
teylynteylyn
17.3k22539
answered 5 hours ago
teylynteylyn
17.3k22539
answered 5 hours ago
teylynteylyn
17.3k22539
answered 5 hours ago
teylynteylyn
17.3k22539
17.3k22539
add a comment |
add a comment |
Jolly is a new contributor. Be nice, and check out our Code of Conduct.
Jolly is a new contributor. Be nice, and check out our Code of Conduct.
Jolly is a new contributor. Be nice, and check out our Code of Conduct.
Jolly 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%2f1409392%2fseries-ignoring-hidden-rows%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
