In Apple Numbers, a spreadsheet software, you’ll be able to sum values from two totally different tabs utilizing a formulation. This may be helpful for consolidating information or creating stories that mix info from a number of sources.
To sum values from two totally different tabs, you need to use the SUMIF perform. The SUMIF perform takes three arguments: the vary of cells you wish to sum, the factors you wish to use to filter the cells, and the vary of cells that incorporates the values you wish to sum. For instance, the next formulation would sum all of the values within the vary A1:A10 on the tab named “Sheet 1” that meet the factors “Fruit” within the vary B1:B10 on the tab named “Sheet 2”: