Spreadsheet: 808768d1670633975-2-formulas-subtract-from-specific-columns-formulatest-1-
Sheet: Data

Department | Name | Target | Jun-22 | Jul-22 | Aug-22 | Sep-22 | Oct-22 | Nov-22 | Dec-22
DeptA | Person1 | 1750 | 2027 | 2204 | 1620 | 1923 | 1649 | 1698 | 1991 |  |  |  | Department | Name | Value 1 | Value 2
DeptB | Person2 | 1300 | 1591 | 2052 | 1904 | 2213 | 2113 | 2179 | 1700 |  |  |  |  | Person19 | -292 | 1558
DeptA | Person1 | 1750 | 1827 | 1948 | 2366 | 2001 | 1675 | 1831 | 2184 |  |  |  | DepC | Person21 | -198 | 2049
DeptB | Person1 | 1750 | 1629 | 1953 | 1666 | 1899 | 2255 | 1861 | 1990 |  |  |  | DepC | Person23 | 26 | -3082
DeptA | Person1 | 1750 | 2310 | 1641 | 2286 | 1730 | 2135 | 1736 | 1852 |  |  |  | DepC | Person25 | -259 | -8191
DeptB | Person6 | 1250 | 1530 | 1778 | 1721 | 1893 | 1972 | 1582 | 2018 |  |  |  | DepC | Person27 | -796 | 1667
DeptA | Person7 | 2485 | 2002 | 2391 | 2004 | 1824 | 1886 | 2349 | 1605 |  |  |  | [NAME] | [NAME] | -202 | 1051
DeptB | Person8 | 2552 | 1852 | 2131 | 2206 | 1781 | 2365 | 2085 | 2111 |  |  |  | [NAME] | Person22 | 771 | 1841
DeptA | Person9 | 251 | 2295 | 1894 | 2051 | 2088 | 1880 | 1692 | 1636 |  |  |  | [NAME] | Person24 | -63 | 2087
DeptB | Person10 | 25455 | 2285 | 1564 | 2197 | 2056 | 1997 | 1625 | 1535 |  |  |  | [NAME] | Person26 | 239 | 1762
DeptA | Person11 | 1255 | 2467 | 1581 | 1947 | 2372 | 1592 | 2204 | 2112 |  |  |  | [NAME] | Person28 | -345 | 1513
DeptB | Person12 | 255 | 2121 | 2002 | 2342 | 1741 | 1964 | 1685 | 2350 |  |  |  | DeptA | Person1 | 293 | 241
DeptA | [NAME] | 654 | 1967 | 2389 | 1995 | 2119 | 1590 | 2066 | 2346 |  |  |  | DeptA | Person1 | 353 | 434
DeptB | Person14 | 654 | 2021 | 1689 | 2199 | 1777 | 2258 | 1909 | 2285 |  |  |  | DeptA | Person1 | 116 | 102
DeptA | Person15 | 651 | 1613 | 2298 | 2152 | 1625 | 1759 | 2371 | 2138 |  |  |  | DeptA | Person11 | -92 | 857
DeptB | Person16 | 651 | 1870 | 2165 | 1753 | 1923 | 1874 | 2339 | 2112 |  |  |  | DeptA | [NAME] | 280 | 1692
DeptA | Person17 | 651 | 1725 | 2411 | 1882 | 2492 | 2172 | 2162 | 1564 |  |  |  | DeptA | Person15 | -233 | 1487
DeptB | Person18 | 651 | 2384 | 1679 | 2291 | 1584 | 1534 | 2400 | 2466 |  |  |  | DeptA | Person17 | -598 | 913
DepC | Person19 | 68 | 2192 | 2159 | 2050 | 2045 | 2112 | 1918 | 1626 |  |  |  | DeptA | Person7 | -744 | -880
[NAME] | [NAME] | 897 | 2407 | 1544 | 2376 | 1922 | 2249 | 2150 | 1948 |  |  |  | DeptA | Person9 | -56 | 1385
DepC | Person21 | 9 | 2286 | 2128 | 1511 | 1647 | 2214 | 2256 | 2058 |  |  |  | DeptB | Person1 | 129 | 240
[NAME] | Person22 | 598 | 2426 | 1689 | 1919 | 1891 | 1987 | 1668 | 2439 |  |  |  | DeptB | Person10 | -90 | -23920
DepC | Person23 | 4987 | 1765 | 2142 | 2496 | 1766 | 2157 | 1879 | 1905 |  |  |  | DeptB | Person12 | 665 | 2095
[NAME] | Person24 | 98 | 2024 | 2071 | 1636 | 1807 | 2392 | 2248 | 2185 |  |  |  | DeptB | Person14 | 376 | 1631
DepC | Person25 | 9848 | 2170 | 2408 | 2237 | 2344 | 1551 | 1916 | 1657 |  |  |  | DeptB | Person16 | -227 | 1461
[NAME] | Person26 | 99 | 2191 | 2225 | 2405 | 2086 | 2185 | 1622 | 1861 |  |  |  | DeptB | Person18 | 66 | 1815
DepC | Person27 | 18 | 2437 | 2420 | 2186 | 1667 | 2234 | 2481 | 1685 |  |  |  | DeptB | Person2 | -479 | 400
[NAME] | Person28 | 9 | 1804 | 2200 | 1972 | 2002 | 1613 | 1867 | 1522 |  |  |  | DeptB | Person6 | 436 | 768
 |  |  |  |  |  |  |  |  |  |  |  |  | DeptB | Person8 | 26 | -441