Related:
- Sort a column by data
- How to sort bookmarks in chrome - Guide
- Spotify sort by genre - Guide
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Display two columns in data validation list but return only one - Guide
2 responses
Use the countif function. For example, if column A contains the t-shirts sizes your formula would be as follows:
=countif(A:A,"s")
The formula above would be for a small t-shirt. You would duplicate the formula for all of the other sizes.
=countif(A:A,"s")
The formula above would be for a small t-shirt. You would duplicate the formula for all of the other sizes.
Thank you. This is what I came up with. Here is an example for my XL shirts: =COUNTIF(F2:F400,"=XL"). I repeated this formula for all sizes.
One other question: (probably another countif function)
I need to capture how many people will be in each class, specifically my 7th and 8th boys and my 7th and 8th girls. These are the 2 classes that are not co-ed. They are gender classes therefore I have to create a formula that combines 2 columns.
I have two columns. One for GENDER and one for GRADE. I have the formula for the 9th grade-Adult. These are co-ed so gender is irrelevant.
The one that is boggling me is when I need to combine 2 columns and count "how many 7th and 8th grade males I have and how many 7th and 8th females I have.
What I am trying to find is the following question marks:
TOTAL STUDENTS BY GRADE:
7/8 Females ?
7/8 Males ?
9 4
10 4
11 0
12 1
College 0
Adults 3
Column C Column D
Gender Grade
M Adult
F Adult
F Adult
F 12
F 10
F 9
F 7
M 10
M 9
M 10
M 10
M 9
M 9
Can you help me on this? Maybe copy and paste this into excel and give me the equation. I am stumped! You are my guru-hero. Let me know if you need further info.
jon
One other question: (probably another countif function)
I need to capture how many people will be in each class, specifically my 7th and 8th boys and my 7th and 8th girls. These are the 2 classes that are not co-ed. They are gender classes therefore I have to create a formula that combines 2 columns.
I have two columns. One for GENDER and one for GRADE. I have the formula for the 9th grade-Adult. These are co-ed so gender is irrelevant.
The one that is boggling me is when I need to combine 2 columns and count "how many 7th and 8th grade males I have and how many 7th and 8th females I have.
What I am trying to find is the following question marks:
TOTAL STUDENTS BY GRADE:
7/8 Females ?
7/8 Males ?
9 4
10 4
11 0
12 1
College 0
Adults 3
Column C Column D
Gender Grade
M Adult
F Adult
F Adult
F 12
F 10
F 9
F 7
M 10
M 9
M 10
M 10
M 9
M 9
Can you help me on this? Maybe copy and paste this into excel and give me the equation. I am stumped! You are my guru-hero. Let me know if you need further info.
jon
