Formula Help

[NeoSez]

I have a the formula below. I want to change it so that it will include everything is under the same category as what is stated in column K.
Eg: Column "K" is Fruit and Column "F" will have apples, oranges, blueberries etc...
Currently, the formula will only pick up one item from column "F" instead of all related items.

=Proper)Indirect("F"&MIN)IF(SUBTOTAL(3,OFFSET(F6,ROW(F6:K10000)-ROW(F6),,1)),ROW(F6:f10000)))))

 

[myall_blues]

Can you post the real formula you are trying to use. The one above has errors such as
- too many closing brackets
- The wrong bracket after =PROPER and presumably MIN)IF

Also some sample data would help.

 

[NeoSez]

Can you post the real formula you are trying to use. The one above has errors such as
- too many closing brackets
- The wrong bracket after =PROPER and presumably MIN)IF

Also some sample data would help.

=PROPER(INDIRECT("F"&MIN(IF(SUBTOTAL(3,OFFSET(F5,ROW(F5:F19988)-ROW(F5),,1)),ROW(F5:F19988)))))

Goal: Modify above formula to sum all FORD (Column "K") cars that are under column "F". Currently, it only sums up one type of car (Column "F").

Tracker	DATE	STATUS	LOCATION	DESCRIPTION	CAR	DATE CLOSED	Age	COMMENTS	CATEGORY	COMPANY
		writeoff			F150				TRUCK	FORD
		drive			FLEX				BUS
		drive			EDGE				SEDAN

 

[alansidman]

Would be beneficial if you provided 8-10 records to show different company scenarios. Additionally, would be beneficial if you mocked up your desired solution for the 8-10 records.

 

[NeoSez]

Would be beneficial if you provided 8-10 records to show different company scenarios. Additionally, would be beneficial if you mocked up your desired solution for the 8-10 records.

Would this help?

1​	Tracker	DATE	STATUS	LOCATION	DESCRIPTION	CAR	DATE CLOSED	Age	COMMENTS	CATEGORY	COMPANY
2​	1001​	1-May-24​	writeoff	home	This is car A	F150	12-May​	11​		TRUCK	FORD
3​	1002​	2-May-24​	drive	garage	This is car A	FLEX		26​		BUS	FORD
4​	1003​	3-May-24​	drive	road	This is car A	EDGE		25​		SEDAN	FORD
5​	1004​	4-May-24​	drive	home	This is car A	F150		24​		TRUCK	FORD
6​	1005​	5-May-24​	drive	garage	This is car A	FLEX		23​		BUS	FORD
7​	1006​	6-May-24​	drive	road	This is car A	F150		22​		TRUCK	FORD
8​	1007​	7-May-24​	writeoff	home	This is car A	FLEX	13-May​	6​		BUS	FORD
9​	1008​	8-May-24​	drive	garage	This is car A	F150		20​		TRUCK	FORD
10​	1009​	9-May-24​	drive	road	This is car A	FLEX		19​		BUS	FORD
11​	1010​	10-May-24​	drive	home	This is car A	edge		18​		SEDAN	FORD
12​	1011​	1-Apr-24​	drive	road	This is car A	RAM		57​		truck	DODGE
13​	1012​	2-Apr-24​	drive	road	This is car A	Charger		56​		SEDAN	DODGE
14​	1013​	3-Apr-24​	drive	road	This is car A	Hornet		55​		SUV	DODGE
15​	1014​	4-Apr-24​	drive	road	This is car A	RAM		54​		truck	DODGE
16​	1015​	5-Apr-24​	drive	road	This is car A	Charger		53​		SEDAN	DODGE
17​	1016​	6-Apr-24​	drive	road	This is car A	Hornet		52​		SUV	DODGE
18​	1017​	7-Apr-24​	drive	road	This is car A	RAM		51​		truck	DODGE
19​	1018​	8-Apr-24​	drive	road	This is car A	Charger		50​		SEDAN	DODGE
20​	1019​	9-Apr-24​	drive	road	This is car A	Hornet		49​		SUV	DODGE
21​	1020​	10-Apr-24​	drive	road	This is car A	Corolla		48​		SEDAN	TOYOTA
22​	1021​	11-Apr-24​	drive	road	This is car A	Prius		47​		SEDAN	TOYOTA
23​	1022​	12-Apr-24​	drive	road	This is car A	Tundra		46​		TRUCK	TOYOTA
24​	1023​	13-Apr-24​	drive	road	This is car A	Corolla		45​		SEDAN	TOYOTA
25​	1024​	14-Apr-24​	drive	road	This is car A	Prius		44​		SEDAN	TOYOTA
26​	1025​	15-Apr-24​	drive	garage	This is car A	Tundra		43​		TRUCK	TOYOTA

 

[Cubist]

Is this what you mean?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Tracker	DATE	STATUS	LOCATION	DESCRIPTION	CAR	DATE CLOSED	Age	COMMENTS	CATEGORY	COMPANY		Company	Count
2	1001	1-May-24	writeoff	home	This is car A	F150	12-May	11		TRUCK	FORD		FORD	10
3	1002	2-May-24	drive	garage	This is car A	FLEX		26		BUS	FORD		DODGE	9
4	1003	3-May-24	drive	road	This is car A	EDGE		25		SEDAN	FORD		TOYOTA	6
5	1004	4-May-24	drive	home	This is car A	F150		24		TRUCK	FORD
6	1005	5-May-24	drive	garage	This is car A	FLEX		23		BUS	FORD
7	1006	6-May-24	drive	road	This is car A	F150		22		TRUCK	FORD
8	1007	7-May-24	writeoff	home	This is car A	FLEX	13-May	6		BUS	FORD
9	1008	8-May-24	drive	garage	This is car A	F150		20		TRUCK	FORD
10	1009	9-May-24	drive	road	This is car A	FLEX		19		BUS	FORD
11	1010	10-May-24	drive	home	This is car A	edge		18		SEDAN	FORD
12	1011	1-Apr-24	drive	road	This is car A	RAM		57		truck	DODGE
13	1012	2-Apr-24	drive	road	This is car A	Charger		56		SEDAN	DODGE
14	1013	3-Apr-24	drive	road	This is car A	Hornet		55		SUV	DODGE
15	1014	4-Apr-24	drive	road	This is car A	RAM		54		truck	DODGE
16	1015	5-Apr-24	drive	road	This is car A	Charger		53		SEDAN	DODGE
17	1016	6-Apr-24	drive	road	This is car A	Hornet		52		SUV	DODGE
18	1017	7-Apr-24	drive	road	This is car A	RAM		51		truck	DODGE
19	1018	8-Apr-24	drive	road	This is car A	Charger		50		SEDAN	DODGE
20	1019	9-Apr-24	drive	road	This is car A	Hornet		49		SUV	DODGE
21	1020	10-Apr-24	drive	road	This is car A	Corolla		48		SEDAN	TOYOTA
22	1021	11-Apr-24	drive	road	This is car A	Prius		47		SEDAN	TOYOTA
23	1022	12-Apr-24	drive	road	This is car A	Tundra		46		TRUCK	TOYOTA
24	1023	13-Apr-24	drive	road	This is car A	Corolla		45		SEDAN	TOYOTA
25	1024	14-Apr-24	drive	road	This is car A	Prius		44		SEDAN	TOYOTA
26	1025	15-Apr-24	drive	garage	This is car A	Tundra		43		TRUCK	TOYOTA
Sheet2

Cell Formulas
Range	Formula
M2:M4	M2	=UNIQUE(K2:K26)
N2:N4	N2	=COUNTIF(K2:K26,M2#)
Dynamic array formulas.

 

[NeoSez]

Is this what you mean?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Tracker	DATE	STATUS	LOCATION	DESCRIPTION	CAR	DATE CLOSED	Age	COMMENTS	CATEGORY	COMPANY		Company	Count
2	1001	1-May-24	writeoff	home	This is car A	F150	12-May	11		TRUCK	FORD		FORD	10
3	1002	2-May-24	drive	garage	This is car A	FLEX		26		BUS	FORD		DODGE	9
4	1003	3-May-24	drive	road	This is car A	EDGE		25		SEDAN	FORD		TOYOTA	6
5	1004	4-May-24	drive	home	This is car A	F150		24		TRUCK	FORD
6	1005	5-May-24	drive	garage	This is car A	FLEX		23		BUS	FORD
7	1006	6-May-24	drive	road	This is car A	F150		22		TRUCK	FORD
8	1007	7-May-24	writeoff	home	This is car A	FLEX	13-May	6		BUS	FORD
9	1008	8-May-24	drive	garage	This is car A	F150		20		TRUCK	FORD
10	1009	9-May-24	drive	road	This is car A	FLEX		19		BUS	FORD
11	1010	10-May-24	drive	home	This is car A	edge		18		SEDAN	FORD
12	1011	1-Apr-24	drive	road	This is car A	RAM		57		truck	DODGE
13	1012	2-Apr-24	drive	road	This is car A	Charger		56		SEDAN	DODGE
14	1013	3-Apr-24	drive	road	This is car A	Hornet		55		SUV	DODGE
15	1014	4-Apr-24	drive	road	This is car A	RAM		54		truck	DODGE
16	1015	5-Apr-24	drive	road	This is car A	Charger		53		SEDAN	DODGE
17	1016	6-Apr-24	drive	road	This is car A	Hornet		52		SUV	DODGE
18	1017	7-Apr-24	drive	road	This is car A	RAM		51		truck	DODGE
19	1018	8-Apr-24	drive	road	This is car A	Charger		50		SEDAN	DODGE
20	1019	9-Apr-24	drive	road	This is car A	Hornet		49		SUV	DODGE
21	1020	10-Apr-24	drive	road	This is car A	Corolla		48		SEDAN	TOYOTA
22	1021	11-Apr-24	drive	road	This is car A	Prius		47		SEDAN	TOYOTA
23	1022	12-Apr-24	drive	road	This is car A	Tundra		46		TRUCK	TOYOTA
24	1023	13-Apr-24	drive	road	This is car A	Corolla		45		SEDAN	TOYOTA
25	1024	14-Apr-24	drive	road	This is car A	Prius		44		SEDAN	TOYOTA
26	1025	15-Apr-24	drive	garage	This is car A	Tundra		43		TRUCK	TOYOTA
Sheet2

Cell Formulas
Range	Formula
M2:M4	M2	=UNIQUE(K2:K26)
N2:N4	N2	=COUNTIF(K2:K26,M2#)
Dynamic array formulas.

Thank you for your reply.
I do have a formula in another box that relies on the first formula. If I can revise this one formula to encompass everything, that would be fantastic.

=COUNTIFS(F:F,$E$1,G:G,">"&$H$1-1)

 

[Cubist]

I do not follow your formula. What is in row 1? Is it not the headers?

 

[NeoSez]

I do not follow your formula. What is in row 1? Is it not the headers?

Yes, it is the header row.

 

[Cubist]

Values in column F:F will never be equal to the header E1 *"Description", so it'll return 0.