How to count how many times a name appears against months over multiple Excel sheets?
up vote
0
down vote
favorite
I have a spreadsheet where I have multiple sheets for different locations and in each location sheet I have names and months. (column B is the name and column C shows different months)
On the main sheet I want to create a list of how many times a name appears against each month, so for example how many times does the name Ben appear against October.
Can this be done using formulas? or would it be a pivot table?
microsoft-excel
edited Nov 15 at 13:00
Blackwood
2,66561727
asked Nov 15 at 12:26
Claire
1
New contributor
Claire 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 |
up vote
0
down vote
favorite
I have a spreadsheet where I have multiple sheets for different locations and in each location sheet I have names and months. (column B is the name and column C shows different months)
On the main sheet I want to create a list of how many times a name appears against each month, so for example how many times does the name Ben appear against October.
Can this be done using formulas? or would it be a pivot table?
microsoft-excel
edited Nov 15 at 13:00
Blackwood
2,66561727
asked Nov 15 at 12:26
Claire
1
New contributor
Claire is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Is the month a "Oct" text or a excel date formatted?
– p._phidot_
Nov 15 at 13:29
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have a spreadsheet where I have multiple sheets for different locations and in each location sheet I have names and months. (column B is the name and column C shows different months)
On the main sheet I want to create a list of how many times a name appears against each month, so for example how many times does the name Ben appear against October.
Can this be done using formulas? or would it be a pivot table?
microsoft-excel
edited Nov 15 at 13:00
Blackwood
2,66561727
asked Nov 15 at 12:26
Claire
1
New contributor
Claire is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have a spreadsheet where I have multiple sheets for different locations and in each location sheet I have names and months. (column B is the name and column C shows different months)
On the main sheet I want to create a list of how many times a name appears against each month, so for example how many times does the name Ben appear against October.
Can this be done using formulas? or would it be a pivot table?
microsoft-excel
microsoft-excel
edited Nov 15 at 13:00
Blackwood
2,66561727
asked Nov 15 at 12:26
Claire
1
New contributor
Claire is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 15 at 13:00
Blackwood
2,66561727
asked Nov 15 at 12:26
Claire
1
New contributor
Claire is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 15 at 13:00
Blackwood
2,66561727
edited Nov 15 at 13:00
Blackwood
2,66561727
edited Nov 15 at 13:00
Blackwood
2,66561727
2,66561727
asked Nov 15 at 12:26
Claire
1
New contributor
Claire is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 15 at 12:26
Claire
1
asked Nov 15 at 12:26
Claire
1
1
New contributor
Claire is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Claire is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Claire is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Is the month a "Oct" text or a excel date formatted?
– p._phidot_
Nov 15 at 13:29
add a comment |
1
Is the month a "Oct" text or a excel date formatted?
– p._phidot_
Nov 15 at 13:29
1
1
Is the month a "Oct" text or a excel date formatted?
– p._phidot_
Nov 15 at 13:29
Is the month a "Oct" text or a excel date formatted?
– p._phidot_
Nov 15 at 13:29
add a comment |
2 Answers
2
active
oldest
votes
up vote
1
down vote
perhaps something like as a starting point.
=COUNTIFS(C:C,"oct",B:B,"ben")
the countifs counts the row if all conditions are met. So only if ben is in column B AND oct is in column C.
You can get more fancy adding cell references for the month and name, or putting your data in a table, etc.
answered Nov 15 at 23:35
gns100
1803
add a comment |
up vote
0
down vote
complementing gns100's answer, you can use the '*' character to select names more easily, if you have only part of the name.
=COUNTIFS(C:C,"oct",B:B,"*ben*")
answered Nov 16 at 0:17
Jamile Martins
214
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
perhaps something like as a starting point.
=COUNTIFS(C:C,"oct",B:B,"ben")
the countifs counts the row if all conditions are met. So only if ben is in column B AND oct is in column C.
You can get more fancy adding cell references for the month and name, or putting your data in a table, etc.
answered Nov 15 at 23:35
gns100
1803
add a comment |
up vote
1
down vote
perhaps something like as a starting point.
=COUNTIFS(C:C,"oct",B:B,"ben")
the countifs counts the row if all conditions are met. So only if ben is in column B AND oct is in column C.
You can get more fancy adding cell references for the month and name, or putting your data in a table, etc.
answered Nov 15 at 23:35
gns100
1803
add a comment |
up vote
1
down vote
up vote
1
down vote
perhaps something like as a starting point.
=COUNTIFS(C:C,"oct",B:B,"ben")
the countifs counts the row if all conditions are met. So only if ben is in column B AND oct is in column C.
You can get more fancy adding cell references for the month and name, or putting your data in a table, etc.
answered Nov 15 at 23:35
gns100
1803
perhaps something like as a starting point.
=COUNTIFS(C:C,"oct",B:B,"ben")
the countifs counts the row if all conditions are met. So only if ben is in column B AND oct is in column C.
You can get more fancy adding cell references for the month and name, or putting your data in a table, etc.
answered Nov 15 at 23:35
gns100
1803
answered Nov 15 at 23:35
gns100
1803
answered Nov 15 at 23:35
gns100
1803
answered Nov 15 at 23:35
gns100
1803
1803
add a comment |
add a comment |
up vote
0
down vote
complementing gns100's answer, you can use the '*' character to select names more easily, if you have only part of the name.
=COUNTIFS(C:C,"oct",B:B,"*ben*")
answered Nov 16 at 0:17
Jamile Martins
214
add a comment |
up vote
0
down vote
complementing gns100's answer, you can use the '*' character to select names more easily, if you have only part of the name.
=COUNTIFS(C:C,"oct",B:B,"*ben*")
answered Nov 16 at 0:17
Jamile Martins
214
add a comment |
up vote
0
down vote
up vote
0
down vote
complementing gns100's answer, you can use the '*' character to select names more easily, if you have only part of the name.
=COUNTIFS(C:C,"oct",B:B,"*ben*")
answered Nov 16 at 0:17
Jamile Martins
214
complementing gns100's answer, you can use the '*' character to select names more easily, if you have only part of the name.
=COUNTIFS(C:C,"oct",B:B,"*ben*")
answered Nov 16 at 0:17
Jamile Martins
214
answered Nov 16 at 0:17
Jamile Martins
214
answered Nov 16 at 0:17
Jamile Martins
214
answered Nov 16 at 0:17
Jamile Martins
214
214
add a comment |
add a comment |
Claire is a new contributor. Be nice, and check out our Code of Conduct.
Claire is a new contributor. Be nice, and check out our Code of Conduct.
Claire is a new contributor. Be nice, and check out our Code of Conduct.
Claire 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%2f1375662%2fhow-to-count-how-many-times-a-name-appears-against-months-over-multiple-excel-sh%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
1
Is the month a "Oct" text or a excel date formatted?
– p._phidot_
Nov 15 at 13:29