I am trying to get the data from Table 1 over to Table 2 for the corresponding dates.
So on Table 2 in cell B2 I'd like it to equal Table 1 Cell D2 + D3 (89)
And also on Table 2 C2 to equal Table 1 D2 (59)
The data is Red is what I'd like to achieve with some form of automation
iMac (2017 – 2020)
Open the Format sidebar with the paintbrush in the toolbar. Type = in a cell and the list of functions will fill the sidebar. Look for SUMIFS.
So in Table 2::B2, you want to add all items picked on the date in A2
=SUMIFS(Table 1::$D,Table 1::A,$A2)
Similarly in Table 2::C2, you want to add all items packed on the date in A2
=SUMIFS(Table 1::$D,Table 1::B,$A2)
Open the Format sidebar with the paintbrush in the toolbar. Type = in a cell and the list of functions will fill the sidebar. Look for SUMIFS.
So in Table 2::B2, you want to add all items picked on the date in A2
=SUMIFS(Table 1::$D,Table 1::A,$A2)
Similarly in Table 2::C2, you want to add all items packed on the date in A2
=SUMIFS(Table 1::$D,Table 1::B,$A2)
Thank you Perfect!!
Trying to move data from multiple lines in 1 table to a single cell in another table
