Excel counting formula

[rameshppc]

STUDENT NAME	CLASS	ADMISSION NUMBER	FEES PAID
NAVEEN	LKG	4001	5000
KANNAN	UKG	4002	8000
NAVEEN	LKG	4001	2000
KARTHIK	1 ST	4003	12000
RAVI	UKG	4004	9000

<tbody>
</tbody>

I WANT TO GENERATE A REPORT LIKE BELOW,

CLASS	NO OF STUDENTS ADMITTED	TOTAL FEES PAID

<tbody>
</tbody>

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,

STUDENT NAME	CLASS	ADMISSION DATE	ADMISSION NUMBER	FEES PAID	REMARKS
KAMAL	LKG	25/04/2018	7001	10,000
SENTHIL	LKG	25/04/2018	7002	9,000
KUMAR	1ST	25/04/2018	7003	11,000
KAMAL	LKG	26/04/2018	7001	2,000

<tbody>
</tbody>

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.