Hello,

Is it possible to reference code in another cell? I'm looking to change code in one cell and it reflects in others. I want to change B2:B16 in A2 and it change the B2:B16 in C2,E2,and G2. Is this possible?

Here is the exact code I have in the following cells.

A2=COUNTIF(B2:B16,"<24")
C2=(COUNTIFS(B2:B16,">24.9",B2:B16,"<48"))
E2=COUNTIFS(B2:B16,">48",B2:B16,"<72")
G2=IF(COUNTIF(B2:B16,">72")=0,NA(),(COUNTIF(B2:B16,">72")))