Can I set the denominator for a cell to be equal to another cell's value?

[BlackLotus]

For example, I'm making a spreadsheet containing wins and losses in League of Legends alongside LP gain and loss. I'd like to set a cell to display a fraction of wins to loss, with the denominator being the number of matches in the spreadsheet. I could update this manually through formatting, or track each in separate cells, but I would prefer having it automatically update, and display in the single cell for OCD's sake. Is there an add on or some way I'm overlooking? Or is it just not feasible?

 

[Michael M]

What cells are the number of matches stored in?
what formula are you currently using
A sample of your data might be helpful

 

[BlackLotus]

They're in columns, I'm using counta to calculate winrate, and the same thing can easily be used to count total number of matches. I can get it to return the number that should be the denominator, but I can't figure out a way to format it to be that number. As far as I'm aware, formatting can't reference cells.

lp gainloss.xlsx
	A	B	C	D	E	F	G
2	Average	Victory	Defeat	average	winrate	Neutral winrate	1.292517
3	12.6	14	17	16.28571	58.82%	56.38%
4	Sum	12	17	Sum	total LP gain
5	126	12	17	114	12
6		11	15
7		14	16
8		13	16
9		12	16
10		13
11		12
12		13
Sheet1

Cell Formulas
Range	Formula
G2	G2	=D3/A3
A3	A3	=AVERAGE(B3:B99)
D3	D3	=AVERAGE(C3:C99)
E3	E3	=COUNTA(B3:B99)/COUNTA(B3:C99)
F3	F3	=G2/(G2+1)
A5	A5	=SUM(B3:B99)
D5	D5	=SUM(C3:C99)
E5	E5	=A5-D5

 

[Michael M]

Can you just tell us what you want to divide what by what in terms of cells ??
what result do you expect to return ?

 

[Rick Rothstein]

Based on your two posts so far, I think you may benefit by reading the following which I have posted in the past. After reading it, go back and answer Michael's questions.

One thing you must keep in mind when you ask a question in a forum... the people you are asking to help you know absolutely nothing about your data, absolutely nothing about how it is laid out in the workbook, absolutely nothing about what you want done with it and absolutely nothing about how whatever it is you want done is to be presented back to you as a result... you must be very specific about describing each of these areas, in detail, and you should not assume that we will be able to "figure it out" on our own. Remember, you are asking us for help... so help us to be able to help you by providing the information we need to do so, even if that information seems "obvious" to you (remember, it is only obvious to you because of your familiarity with your data). To sum up... we only know what you tell us, nothing more.

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this what you mean?

21 09 14.xlsm
	B	C	D	E
1	Victory	Defeat		winrate
2				9/15
3	12	17
4	12	17
5	11	15
6	14	16
7	13	16
8	12	16
9	13
10	12
11	13
12
Fraction

Cell Formulas
Range	Formula
E2	E2	=TEXT(COUNTA(B3:B99)/COUNTA(B3:C99),"?/"&COUNTA(B3:C99))

 

[BlackLotus]

Welcome to the MrExcel board!

Is this what you mean?

21 09 14.xlsm
	B	C	D	E
1	Victory	Defeat		winrate
2				9/15
3	12	17
4	12	17
5	11	15
6	14	16
7	13	16
8	12	16
9	13
10	12
11	13
12
Fraction

Cell Formulas
Range	Formula
E2	E2	=TEXT(COUNTA(B3:B99)/COUNTA(B3:C99),"?/"&COUNTA(B3:C99))

Yes, that is exactly it, is it the & that makes that function?

 

[Peter_SSs]

Yes, that is exactly it,

Glad it was what you wanted.

is it the & that makes that function?

the &COUNTA(B3:C99) makes the denominator.