Spreadsheet: 741643d1627225881-dynamically-referenced-rows-across-two-worksheets-sample
Sheet: Formula Sheet

XYZ0AA00AB | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZ0AAC0C0 | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZ3AA00AB | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZ3AAC015 | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
[NAME] | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZ0AA001F | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
Revenue | =sum(B1:B6)
Revenue | (Retrieved value from system)
[NAME] | =B7-B8
XYZ0AAABAB | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZ3AAAB1F | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZ3AAAB17 | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZ0AAAB1F | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZ0AAABCC | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
S Revenue | =sum(B9:B13)
S Revenue | (Retrieved value from system)
[NAME] | =B16-B17
XYZ0AA40AB | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZ0AA401C | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZ0AA4013 | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZ0AA30AB | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZ0AA30AA | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
[NAME] | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZAA140AB | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZ0AA401F | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
XYZAAAB0C0 | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
[NAME] | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
C Revenue | =sum(B16:B25)
XYZ0AA0014 | Formula1 | Formula2 | Formula3 | Formula4 | Formula5 | Formula6 | Formula7 | Formula8 | Formula9 | Formula10 | Formula11 | Formula12 | Formula13 | Formula14
RC Deductions | =sum(B28)