How to change a chart based on what customer code is typed into a cell / Count customer data

[K100PAX]

Hello, I have a load of data which is split by customers. I want to be able to add a tab with a load of charts on it but I want to be able to key a customer code into (for example) cell A1 and when I hit "ENTER" the chart data updates.

I also need a formula to count the amount of responses a customer has had in a particular column. Kinda like a COUNTIFS as it needs to be based on the customer. The data cells could contain numbers, test or nothing at all

Its almost like I need =COUNTIFS(DATA!J:J,SUMMARY!B4,DATA!AF:AF,THIS PART COUNTS THE NUMBER OF CELLS THAT THIS CUSTOMER HAS IN THE DATA RANGE AF:AF THAT CONTAIN SOMETHING)

Any help would be appreciated

Thank you all

 

[awoohaw]

Have you considered using PIVOT Tables and slicers. The slicer does not show up in the mini worksheet print, see the image under the minisheet below:

Mr excel questions 55.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1		<< CUSTOMER	Customer Data
2			Customer	Order Date	Widget Type	Widgets Ordered	Widgets Returned
3			A	2023-04-06	Thingamabob	78	4			Column Labels
4			C	2023-05-30	Thingamabob	96	6			Sum of Widgets Ordered							Sum of Widgets Returned							Total Sum of Widgets Ordered	Total Sum of Widgets Returned
5			F	2023-02-02	Spinner	61	0			Jan	Feb	Mar	Apr	May	Jun	Jul	Jan	Feb	Mar	Apr	May	Jun	Jul
6			C	2023-01-02	Spinner	55	11
7			D	2023-02-26	Spinner	46	2		Row Labels
8			D	2023-04-10	Spinner	55	4		B			91		63	30				1		3	9		184	13
9			C	2023-07-02	Spinner	50	2		Spinner			91		63	30				1		3	9		184	13
10			G	2023-01-07	Thingamabob	43	10		C	148				216	168	50	19				20	17	2	582	58
11			C	2023-01-14	Spinner	18	6		Blob	75				41	16		2				11	0		132	13
12			C	2023-01-06	Blob	75	2		Spinner	73				79	57	50	17				3	11	2	259	33
13			E	2023-02-24	Thingamabob	14	5		Thingamabob					96	95						6	6		191	12
14			D	2023-02-05	Spinner	74	10		D		120	100	93	20	17			12	3	13	11	5		350	44
15			C	2023-06-20	Spinner	57	11		Blob			100							3					100	3
16			A	2023-07-17	Blob	39	3		Spinner		120		93	20				12		13	11			233	36
17			F	2023-03-25	Thingamabob	72	7		Thingamabob						17							5		17	5
18			A	2023-03-22	Blob	66	8		E	63	120	96				97	0	25	10				7	376	42
19			A	2023-06-06	Spinner	83	9		Blob	63							0							63	0
20			E	2023-02-22	Spinner	20	10		Spinner		20					97		10					7	117	17
21			D	2023-03-02	Blob	100	3		Thingamabob		100	96						15	10					196	25
22			A	2023-03-21	Blob	78	0		F	87	61	72		86			5	0	7		7			306	19
23			B	2023-06-11	Spinner	30	9		Spinner		61							0						61	0
24			E	2023-07-10	Spinner	97	7		Thingamabob	87		72		86			5		7		7			245	19
25			D	2023-06-17	Thingamabob	17	5		G	43					52	90	10					5	10	185	25
26			F	2023-01-21	Thingamabob	87	5		Blob							90							10	90	10
27			D	2023-04-04	Spinner	38	9		Spinner						52							5		52	5
28			G	2023-07-23	Blob	90	10		Thingamabob	43							10							43	10
29			G	2023-06-13	Spinner	52	5		Grand Total	341	301	359	93	385	267	237	34	37	21	13	41	36	19	1983	201
30			F	2023-05-27	Thingamabob	86	7
31			C	2023-06-01	Thingamabob	95	6
32			A	2023-04-17	Blob	87	11
33			B	2023-03-11	Spinner	91	1
34			C	2023-05-08	Blob	41	11
35			C	2023-05-01	Spinner	79	3
36			B	2023-05-01	Spinner	63	3
37			E	2023-03-20	Thingamabob	96	10
38			C	2023-06-20	Blob	16	0
39			E	2023-02-10	Thingamabob	86	10
40			D	2023-05-01	Spinner	20	11
41			E	2023-01-05	Blob	63	0
42			A	2023-04-23	Spinner	10	4
K100PAX