Formula help

[aysam]

I have a school timetable with 100 rows and 100 columns and I want to count how many science classes are there for each grade. I have a column for each school subject

 

[keef2]

Book1
	A	B	C
1	Math		4
2	Science
3	History
4	Science
5	Science
6	History
7	Math
8	Art
9	Music
10	Science
Sheet1

Cell Formulas
Range	Formula
C1	C1	=COUNTIF(A:A,"science")

 

[Automatrix]

Hard to visualize, can you show us your data?

 

[keef2]

Or somethign like this if you have 2 criteria. Yellow would be variable and you could input what you want there to provide a different output.

Book1
	A	B	C	D	E	F	G	H
1	Subject	Grade			Output		Grade	1
2	Math	1			2		Subject	Science
3	Science	1
4	History	1
5	Science	2
6	Science	1
7	History	2
8	Math	2
9	Art	2
10	Music	2
11	Science	3
Sheet1

Cell Formulas
Range	Formula
E2	E2	=COUNTIFS(A:A,H2,B:B,H1)

 

[aysam]

Book1
	A	B	C
1	Math		4
2	Science
3	History
4	Science
5	Science
6	History
7	Math
8	Art
9	Music
10	Science
Sheet1

Cell Formulas
Range	Formula
C1	C1	=COUNTIF(A:A,"science")

Thanks for your reply but it is not thst simple

 

[keef2]

Thanks for your reply but it is not thst simple

Provide a sample of your data with Xlb22 or a screen shot or something then please.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

It would help if you could post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[aysam]

So appreciated. Here s a sample of my data

 

[aysam]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

It would help if you could post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

I should try

 

[aysam]

Waiting