Subtotal by Date (a little different than normal)

[mikemathis]

Hi all, I have a sheet where there is the possibility of multiple rows with the same date which I want to subtotal. However, I don't want to have the normal subtotal separate row, rather, I want it in a specific cell. I'm wondering if there is a formula which could read the dates (which would ALWAYS be in order), and if the dates were the same, then subtotal a column into a cell.

	A	B	C	D	E	F
1​	Check	Date	Description	Income Category	Item Total	Total Deposit
2​	DEP	2/17/2023​	Offering	Regular Offering	$ 716.00
3​	DEP	2/17/2023​	$20 Improvement	Category6	$ 20.00
4​	DEP	2/17/2023​	$100 OGHS	Category8	$ 100.00	$ 836.00

 

[PeteWright]

Is this what you need?

Book1.xlsx
	A	B	C	D	E	F
1	Check	Date	Description	Income Category	Item Total	Total Deposit
2	DEP	2/17/2023	Offering	Regular Offering	$ 716.00	$ -
3	DEP	2/17/2023	$20 Improvement	Category6	$ 20.00	$ -
4	DEP	2/17/2023	$100 OGHS	Category8	$ 100.00	$ 836.00
5	BLUB	2/25/2023	blubb	Category1	$ 50.00	$ 50.00
6	BLAH	2/27/2023	blahblah	Category2	$ 70.00	$ -
7	BLAH	2/27/2023	blahblah	Category2	$ 40.00	$ 110.00
Sheet1

Cell Formulas
Range	Formula
F2:F7	F2	= SUMPRODUCT( ( B2<>B3) * ($B$2:B7=B2) * ($E$2:E7) )

 

[mikemathis]

That is THE THING! Thanks so much. Works a charm!

 

[PeteWright]

Nice. Glad I could help