Count of Column F and Sum of Column G

[Muthukrishnan V]

Book6.xlsx
	A	B	C	D	E	F	G
1	Date	Expenses		Date		Specified Date	Expenses
2	23-04-2024	1,000		23-04-2024		23-04-2024	1,000
3	04-04-2024	12,000				23-04-2024	555
4	17-04-2024	17,043		Output:		02-01-1900	92,365
5	23-04-2024	555		F4= 2
6	24-04-2024	600		G4=1555
7	18-04-2024	6,500
8
9
10
11
12
13
14
15
16
Sheet24

Cell Formulas
Range	Formula
D2	D2	=A2
F2:G4	F2	=LET(f,FILTER(A2:B16,A2:A16=D2),ct,ROWS(f),s,SUM(f),IFERROR(VSTACK(f,HSTACK(ct,s)),""))
Dynamic array formulas.

I request help to kindly amend the formula so that column F gives the number of counts and column G gives the sum total. Thanks

 

[Cubist]

Since you're using a dynamic array, the count will be formatted as date if you want it below it (F4). Why?

=LET(f,FILTER(A2:B16,A2:A16=D2),ct,ROWS(f),s,SUM(CHOOSECOLS(f,2)),IFERROR(VSTACK(f,HSTACK(ct,s)),""))

 

[Muthukrishnan V]

Since you're using a dynamic array, the count will be formatted as date if you want it below it (F4). Why?

=LET(f,FILTER(A2:B16,A2:A16=D2),ct,ROWS(f),s,SUM(CHOOSECOLS(f,2)),IFERROR(VSTACK(f,HSTACK(ct,s)),""))

Sir, what shall I do to achieve the correct output? Col F is formatted as Date. Should I change Col F to text? Column G is formatted as number. Kindly correct me sir,

 

[Cubist]

I'd recommend not having it in the same column but I don't know what your intention is.

 

[Muthukrishnan V]

I'd recommend not having it in the same column but I don't know what your intention is.

Thank you Mr Cubist sir, I value your recommendations sir. Kindly amend the formula to give sum total of Column G only and Count of Col F is NOT required.

 

[Cubist]

Book1
	A	B	C	D	E	F	G
1	Date	Expenses		Date		Specified Date	Expenses
2	4/23/24	1,000		45405		4/23/24	1,000.0
3	4/4/24	12,000				4/23/24	555.0
4	4/17/24	17,043		Output:			1555
5	4/23/24	555		F4= 2
6	4/24/24	600		G4=1555
7	4/18/24	6,500
Sheet8

Cell Formulas
Range	Formula
D2	D2	=A2
F2:G4	F2	=LET(f,FILTER(A2:B16,A2:A16=D2),s,SUM(CHOOSECOLS(f,2)),VSTACK(f,HSTACK("",s)))
Dynamic array formulas.

 

[Muthukrishnan V]

Thank you Mr Cubist sir, Issue resolved. I am thankful to our Forum.