Relative vs Absolute:
Relative: D1 =( A1 * B1 + C1)
Absolute =(A1 *B1 + $C$1)
Copy And Paste into D2:
Relative: D2 = (A2 * B2 / C2)
Absolute: D2 =(A2 * B2/ C1) ; The money sign keeps the same column or row
Making Relative Comparisons between sells
=Countifs [ Renge1, criteria 1, Range 2, criteria 2 ]
example:
A1:A10 are data values
A11 = mean(A1:A10)
A12 = max(A1:A10)
B1 = COUNTIFS [ A1:A10, ">="& A11, A1:A10, "<="&A12] ;
in here The " " encloses the condition, and the symbol & makes cell into string (an actual value)
B1 will return the number of cells that fall between the average and the maximum.
