How do I keep a running total of data in a column in Excel?Count unique names in excel column rangeHow to sort a column by occurrence count in Excel?Excel pivot tables: reverse running totalPopulate one column with data from a list and match other column dataSort one column by another and keep proceeding rows in the same orderHow to search in column A for specific data and return an answer in column B (“Yes” or “No”)Excel find and replace: prepend a number to all rows that contain bold numbers in a columnExcel pasting - How to keep cell-row relationship when pastingTotal counts of a three-cell pattern in ExcelMicrosoft Excel - sort data alphanumeric
How do I present a future free of gender stereotypes without being jarring or overpowering the narrative?
What does 'in attendance' mean on a death certificate - England?
Calculus, water poured into a cone: Why is the derivative non-linear?
A quine of sorts
Magento2: Custom module not working
Hard for me to understand one tip written in "The as-if rule" of cppreference
Would skyscrapers tip over if people fell sideways?
Dynamic Sql Query - how to add an int to the code?
Why doesn't SpaceX land boosters in Africa?
Correct use of the the idiom 'Гнать/Катить бочку'
How would one prevent political gerrymandering?
Why isn't UDP with reliability (implemented at Application layer) a substitute of TCP?
Security Patch SUPEE-11155 - Possible issues?
Installed software from source, how to say yum not to install it from package?
The Lucas argument vs the theorem-provers -- who wins and why?
In Kyrie Eleison, what does "derramo aos teus pes minha vida" mean?
Where to connect the fuse and why?
How do I keep a running total of data in a column in Excel?
What are the children of two Muggle-borns called?
I just started; should I accept a farewell lunch for a coworker I don't know?
Do home values typically rise and fall consistently across different price ranges?
Sort a list of lists by increasing order of elements
Automorphisms and epimorphisms of finite groups
What does 5d4 x 10 gp mean?
How do I keep a running total of data in a column in Excel?
Count unique names in excel column rangeHow to sort a column by occurrence count in Excel?Excel pivot tables: reverse running totalPopulate one column with data from a list and match other column dataSort one column by another and keep proceeding rows in the same orderHow to search in column A for specific data and return an answer in column B (“Yes” or “No”)Excel find and replace: prepend a number to all rows that contain bold numbers in a columnExcel pasting - How to keep cell-row relationship when pastingTotal counts of a three-cell pattern in ExcelMicrosoft Excel - sort data alphanumeric
Imagine a column in Excel that has either "Y" or "N" in it.
I want the column next to it to keep a running count of the number of Y's, but the Y's and N's appear in a random order and I cannot sort by them.
The end result would look like this:
Y:1
N:
N:
Y:2
Y:3
N:
Y:4
N:
Y:5
Y:6
Y:7
etc..
Is this possible?
microsoft-excel worksheet-function
edited 38 mins ago
Peter Mortensen
8,46616 gold badges61 silver badges85 bronze badges
asked 9 hours ago
Dean HarrisonDean Harrison
261 bronze badge
New contributor
Dean Harrison 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 |
Imagine a column in Excel that has either "Y" or "N" in it.
I want the column next to it to keep a running count of the number of Y's, but the Y's and N's appear in a random order and I cannot sort by them.
The end result would look like this:
Y:1
N:
N:
Y:2
Y:3
N:
Y:4
N:
Y:5
Y:6
Y:7
etc..
Is this possible?
microsoft-excel worksheet-function
edited 38 mins ago
Peter Mortensen
8,46616 gold badges61 silver badges85 bronze badges
asked 9 hours ago
Dean HarrisonDean Harrison
261 bronze badge
New contributor
Dean Harrison 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 |
Imagine a column in Excel that has either "Y" or "N" in it.
I want the column next to it to keep a running count of the number of Y's, but the Y's and N's appear in a random order and I cannot sort by them.
The end result would look like this:
Y:1
N:
N:
Y:2
Y:3
N:
Y:4
N:
Y:5
Y:6
Y:7
etc..
Is this possible?
microsoft-excel worksheet-function
edited 38 mins ago
Peter Mortensen
8,46616 gold badges61 silver badges85 bronze badges
asked 9 hours ago
Dean HarrisonDean Harrison
261 bronze badge
New contributor
Dean Harrison is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Imagine a column in Excel that has either "Y" or "N" in it.
I want the column next to it to keep a running count of the number of Y's, but the Y's and N's appear in a random order and I cannot sort by them.
The end result would look like this:
Y:1
N:
N:
Y:2
Y:3
N:
Y:4
N:
Y:5
Y:6
Y:7
etc..
Is this possible?
microsoft-excel worksheet-function
microsoft-excel worksheet-function
edited 38 mins ago
Peter Mortensen
8,46616 gold badges61 silver badges85 bronze badges
asked 9 hours ago
Dean HarrisonDean Harrison
261 bronze badge
New contributor
Dean Harrison is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 38 mins ago
Peter Mortensen
8,46616 gold badges61 silver badges85 bronze badges
asked 9 hours ago
Dean HarrisonDean Harrison
261 bronze badge
New contributor
Dean Harrison is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 38 mins ago
Peter Mortensen
8,46616 gold badges61 silver badges85 bronze badges
edited 38 mins ago
Peter Mortensen
8,46616 gold badges61 silver badges85 bronze badges
edited 38 mins ago
Peter Mortensen
8,46616 gold badges61 silver badges85 bronze badges
8,46616 gold badges61 silver badges85 bronze badges
asked 9 hours ago
Dean HarrisonDean Harrison
261 bronze badge
New contributor
Dean Harrison is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 9 hours ago
Dean HarrisonDean Harrison
261 bronze badge
asked 9 hours ago
Dean HarrisonDean Harrison
261 bronze badge
261 bronze badge
New contributor
Dean Harrison is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Dean Harrison 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
Yes, it's possible, enter below formula in your second column and fill it down.
=IF(A2="Y",COUNTIF($A$2:A2,"Y"),"")
answered 9 hours ago
Máté JuhászMáté Juhász
15.3k6 gold badges35 silver badges52 bronze badges
Excellent thank you.
– Dean Harrison
9 hours ago
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
);
);
Dean Harrison 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%2f1454026%2fhow-do-i-keep-a-running-total-of-data-in-a-column-in-excel%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
Yes, it's possible, enter below formula in your second column and fill it down.
=IF(A2="Y",COUNTIF($A$2:A2,"Y"),"")
answered 9 hours ago
Máté JuhászMáté Juhász
15.3k6 gold badges35 silver badges52 bronze badges
Excellent thank you.
– Dean Harrison
9 hours ago
add a comment |
Yes, it's possible, enter below formula in your second column and fill it down.
=IF(A2="Y",COUNTIF($A$2:A2,"Y"),"")
answered 9 hours ago
Máté JuhászMáté Juhász
15.3k6 gold badges35 silver badges52 bronze badges
Excellent thank you.
– Dean Harrison
9 hours ago
add a comment |
Yes, it's possible, enter below formula in your second column and fill it down.
=IF(A2="Y",COUNTIF($A$2:A2,"Y"),"")
answered 9 hours ago
Máté JuhászMáté Juhász
15.3k6 gold badges35 silver badges52 bronze badges
Yes, it's possible, enter below formula in your second column and fill it down.
=IF(A2="Y",COUNTIF($A$2:A2,"Y"),"")
answered 9 hours ago
Máté JuhászMáté Juhász
15.3k6 gold badges35 silver badges52 bronze badges
answered 9 hours ago
Máté JuhászMáté Juhász
15.3k6 gold badges35 silver badges52 bronze badges
answered 9 hours ago
Máté JuhászMáté Juhász
15.3k6 gold badges35 silver badges52 bronze badges
answered 9 hours ago
Máté JuhászMáté Juhász
15.3k6 gold badges35 silver badges52 bronze badges
15.3k6 gold badges35 silver badges52 bronze badges
Excellent thank you.
– Dean Harrison
9 hours ago
add a comment |
Excellent thank you.
– Dean Harrison
9 hours ago
Excellent thank you.
– Dean Harrison
9 hours ago
Excellent thank you.
– Dean Harrison
9 hours ago
add a comment |
Dean Harrison is a new contributor. Be nice, and check out our Code of Conduct.
Dean Harrison is a new contributor. Be nice, and check out our Code of Conduct.
Dean Harrison is a new contributor. Be nice, and check out our Code of Conduct.
Dean Harrison 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%2f1454026%2fhow-do-i-keep-a-running-total-of-data-in-a-column-in-excel%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
