Rank or countif if separate sheets

[Buzby]

Hi - not sure this is even possible - i want to try and rank on the summary sheet rather than put in an additional calculation column in the data sheet

Summary sheet : needs to show ranking of Apples
Data Sheet : 4 columns Q1, Q2, Q3, Q4 which sums up to the LTM calc

Division	Client	2023 LTM
Sainsburys	Apples	244,020

 

[Sergius]

Hello! If you understand you correctly

Book1.xlsm
	R	S	T	U	V	W
9	Division	Client	Q1	Q2	Q3	Q4
10	Sainsburys	Apples	244,02	214,00	325,00	215,00
11	S	Apples	452,00	128,00	147,00	369,00
12
13	Row Labels	Sum of 2023 LTM	Rank
14	S	1096,00	1
15	Sainsburys	998,02	2
Sheet1

Create a calculated field “2023 LTM” and add to the “values”. Then duplicate it again, but in the settings you will go to the second tab “Show the values of how”. There, select the "Rank Largest to Smallest" parameter.