Help with Filter and Sort

[CTMom]

Hi I have a table with countif formula - a list of names and sales numbers - which is pretty simple but the sort or filter function is not working. (I cannot post the actual sheet here as the xl2bb add in is not working either!).

Column A - names in text format
Column B -

=COUNTIF(Grossdata!$T$7:$T$3249,Summary!a8)

where Grossdata is on another worksheet and A1 = name.

Just trying to count number of sales by name and then sort by largest to smallest. Neither Sort or Filter is working. there are no blank cells and no error messges or NA, etc. So am completely at a loss as to why it is not working

Any help greatly appreciated.

 

[Alex Blakenburg]

I am not sure I have the requirements right but see if this is what you had in mind.
PS: assuming the formula resides on the Sheet Summary, I would normally drop the sheet name in the reference and just use "A8", it means the formula has less clutter in it.

20221009 Filter Sort Count CTMom.xlsx
	A	B	C	D
7	Criteria	Count	Filter Name	Filter Amt
8	Tom	3	Tom	3000
9			Tom	300
10			Tom	30
Summary

Cell Formulas
Range	Formula
B8	B8	=COUNTIF(Grossdata!$T$7:$T$3249,Summary!A8)
C8:D10	C8	=SORT(FILTER(Grossdata!$T$7:$U$3249,Grossdata!$T$7:$T$3249=Summary!A8),2,-1)
Dynamic array formulas.

My test data in case anyone else wants to buy in.

20221009 Filter Sort Count CTMom.xlsx
	T	U
6	Names	Sales
7	John	20
8	Tom	30
9	Joan	40
10	Wendy	50
11	Bob	60
12	John	200
13	Tom	300
14	Joan	400
15	Wendy	500
16	Bob	600
17	John	2000
18	Tom	3000
19	Joan	4000
20	Wendy	5000
21	Bob	6000
Grossdata

 

[Fluff]

If you are trying to sort the data using the Sort button on the Data tab, then the problem is the part in red

=COUNTIF(Grossdata!$T$7:$T$3249,Summary!a8)

You should never refer to the name of the sheet the formula is on. Just use

=COUNTIF(Grossdata!$T$7:$T$3249,a8)