Excel counting formula

[rameshppc]

[TABLE="width: 500"]
<tbody>[TR]
[TD]STUDENT NAME
[/TD]
[TD]CLASS
[/TD]
[TD]ADMISSION NUMBER
[/TD]
[TD]FEES PAID
[/TD]
[/TR]
[TR]
[TD]NAVEEN
[/TD]
[TD]LKG
[/TD]
[TD]4001
[/TD]
[TD]5000
[/TD]
[/TR]
[TR]
[TD]KANNAN
[/TD]
[TD]UKG
[/TD]
[TD]4002
[/TD]
[TD]8000
[/TD]
[/TR]
[TR]
[TD]NAVEEN
[/TD]
[TD]LKG
[/TD]
[TD]4001
[/TD]
[TD]2000
[/TD]
[/TR]
[TR]
[TD]KARTHIK
[/TD]
[TD]1 ST
[/TD]
[TD]4003
[/TD]
[TD]12000
[/TD]
[/TR]
[TR]
[TD]RAVI
[/TD]
[TD]UKG
[/TD]
[TD]4004
[/TD]
[TD]9000
[/TD]
[/TR]
</tbody>[/TABLE]

I WANT TO GENERATE A REPORT LIKE BELOW,
[TABLE="width: 500"]
<tbody>[TR]
[TD]CLASS
[/TD]
[TD]NO OF STUDENTS ADMITTED
[/TD]
[TD]TOTAL FEES PAID
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

KINDLY ADVISE FORMULA TO DO THE NEEDFUL.

 

[jorismoerings]

Hi,

try something like this:

Book1
	A	B	C	D
1	STUDENT NAME	CLASS	ADMISSION NUMBER	FEES PAID
2	NAVEEN	LKG	4001	5000
3	KANNAN	UKG	4002	8000
4	NAVEEN	LKG	4001	2000
5	KARTHIK	1 ST	4003	12000
6	RAVI	UKG	4004	9000
7
8	Report
9	CLASS	NO OF STUDENTS ADMITTED	TOTAL FEES PAID
10	LKG	1	7000
11	UKG	2	17000
12	1 ST	1	12000
Sheet2

Cell Formulas
Range	Formula
C10	=SUMIF($B$2:$B$6,A10,$D$2:$D$6)
A10	{=IFERROR(INDEX($B$2:$B$6,MATCH(0,COUNTIF($A$9:A9,$B$2:$B$6),0)),"")}
B10	{=SUM(IF((A10=$B$2:$B$6),1/COUNTIFS($B$2:$B$6,A10,$A$2:$A$6,$A$2:$A$6)))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[rameshppc]

[TABLE="width: 500"]
<tbody>[TR]
[TD]STUDENT NAME[/TD]
[TD]CLASS[/TD]
[TD]ADMISSION NO[/TD]
[TD]FEES PAID[/TD]
[/TR]
[TR]
[TD]NAVEEN[/TD]
[TD]LKG[/TD]
[TD]4001[/TD]
[TD]5000[/TD]
[/TR]
[TR]
[TD]KANNAN[/TD]
[TD]UKG[/TD]
[TD]4002[/TD]
[TD]8000[/TD]
[/TR]
[TR]
[TD]NAVEEN[/TD]
[TD]1 ST[/TD]
[TD]4003[/TD]
[TD]12000[/TD]
[/TR]
[TR]
[TD]KARTHIK[/TD]
[TD]UKG[/TD]
[TD]4004[/TD]
[TD]5000[/TD]
[/TR]
[TR]
[TD]NAVEEN[/TD]
[TD]LKG[/TD]
[TD]4001[/TD]
[TD]2000[/TD]
[/TR]
[TR]
[TD]UMAR[/TD]
[TD]LKG[/TD]
[TD]BOOKING[/TD]
[TD]1000[/TD]
[/TR]
</tbody>[/TABLE]

Thanks for your immediate response..

A10 & C10 formulas are working nice..
B10 I getting the answer "1" for all rows (UKG, 1st, etc..)
Pls advise..

Also there is a chance of same student name in different class (A2 & A4) i shown in the above chart.
So advise formula based on this..

Also we need to omit in our report of the "Booking" mentioned in "Admission no" column.

Kindly advise to do the needful.

 

[rameshppc]

Hi experts..

I am waiting for your valuable solution.

 

[Aladin Akyurek]

Hi experts..

I am waiting for your valuable solution.

Would you also post the expected results literally?

 

[rameshppc]

Hi Aladin..

Cell B10 resulted "1" for all rows (LKG, UKG, !st etc..) instead of number of students admitted in the particular class.

Also consider to generate report for the same student name with different class asked in my previous post

Then, we need to omit the "Booking" mentioned in "Admission no" column.

kindly advise

 

[Aladin Akyurek]

Given your input data in your initial post, try to post the output that is based on that input.

 

[rameshppc]

Given your input data in your initial post, try to post the output that is based on that input.

sorry how do i insert my input data here?

it contains row 4 to 55..

 

[Aladin Akyurek]

sorry how do i insert my input data here?

it contains row 4 to 55..

You already have posted a sample in post #1 . I'm only asking what the output must be based on that input...

 

[rameshppc]

The b10 cell out put not resulted as per the input data.