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