Jul 27 2020 01:35 PM
Jul 27 2020 02:04 PM
@adamc26 I think you want SUMIF()
=SUMIF(Sheet2!B:B, A7, Sheet2!C:C)
This assumes the actual total tables is on Sheet2 and the room name is in col 2 and the $$ in col C. Paste this starting in row 4 of the Actual Cash Out column.