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.

 

[rameshppc]

Hi joris..

You are really great..
The formula working perfectly..
Thanks for your effort...

My report goes wrong, while the input data rows increases as below,[TABLE="width: 500"]
<tbody>[TR]
[TD]STUDENT NAME
[/TD]
[TD]CLASS
[/TD]
[TD]ADMISSION DATE
[/TD]
[TD]ADMISSION NUMBER
[/TD]
[TD]FEES PAID
[/TD]
[TD]REMARKS
[/TD]
[/TR]
[TR]
[TD]KAMAL
[/TD]
[TD]LKG
[/TD]
[TD]25/04/2018[/TD]
[TD]7001[/TD]
[TD]10,000
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SENTHIL
[/TD]
[TD]LKG
[/TD]
[TD]25/04/2018
[/TD]
[TD]7002
[/TD]
[TD]9,000
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KUMAR
[/TD]
[TD]1ST
[/TD]
[TD]25/04/2018
[/TD]
[TD]7003
[/TD]
[TD]11,000
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KAMAL
[/TD]
[TD]LKG
[/TD]
[TD]26/04/2018
[/TD]
[TD]7001
[/TD]
[TD]2,000
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Row 1 student name "kamal" paying his balance fees on next day (26/04/2018)
Admission number is same, so it will not increase the number of admitted seats.
Now how do i update in the formula....

 

[jorismoerings]

Hi,

It's not wise to constantly add extra criteria. Try to post your question as complete as possible!

Try this:

Book1
	A	B	C	D	E	F	G	H	I	J
1	STUDEN NAME	CLASS	ADMISSION DATE	ADMISSION NUMBER	FEES PAID	REMARKS		Report
2	L. NAVEEN	LKG	25-4-2018	7001	10000			CLASS	NO OF STUDENTS ADMITTED	TOTAL FEES PAID
3	SENTHIL	LKG	25-4-2018	7002	9000			LKG	6	75500
4	KUMAR	1 ST	26-4-2018	7003	11000			1 ST	6	83000
5	DINESH	LKG	26-4-2018	7004	10000			UKG	4	41500
6	KARAN	UKG	26-4-2018	7005	7000			5 TH	2	49000
7	MOORTHY	1 ST	26-4-2018	7006	15000			3 RD	2	40000
8	VIGNESH	LKG	26-4-2018	WAITING	1000	RTE
9	NAZER	LKG	26-4-2018	7007	8500
10	ASIF	1 ST	26-4-2018	7008	14000
11	KARTHIK	5 TH	30-4-2018	7009	25000
12	NAREN	3 RD	30-4-2018	7010	20000
13	SUNDAR	1 ST	30-4-2018	7011	15000
14	HASHINI	UKG	30-4-2018	7012	11500
15	LATHA	UKG	30-4-2018	7013	12000
16	NIRANJAN	LKG	30-4-2018	WAITING	1000	RTE
17	KAMAL	UKG	30-4-2018	7014	11000
18	VINAY	1 ST	30-4-2018	7015	15000
19	MEENA	LKG	30-4-2018	7016	7000
20	VENU	LKG	30-4-2018	7017	10000
21	CHANDRAN	1 ST	30-4-2018	7018	13000
22	LAVANYA	5 TH	2-5-2018	7019	24000
23	MOUSHMI	3 RD	2-5-2018	7020	20000
24	KAMAL	LKG	25-4-2018	7001	10000
25	SENTHIL	LKG	25-4-2018	7002	9000
26	KUMAR	1ST	25-4-2018	7003	11000
27	KAMAL	LKG	26-4-2018	7001	2000
Sheet1

Cell Formulas
Range	Formula
J3	=SUMPRODUCT(($B$2:$B$27=$H3)*($D$2:$D$27<>"waiting")*($E$2:$E$27))
H3	{=IFERROR(INDEX($B$2:$B$27,MATCH(0,COUNTIF($H$2:H2,$B$2:$B$27),0)),"")}
I3	{=SUM(--(FREQUENCY(IF($B$2:$B$27=H3,$D$2:$D$27),$D$2:$D$27)>0))}
Press CTRL+SHIFT+ENTER to enter array formulas.