You can't! And you can't use this worksheet as source for any formulas, unless you get every single value as link to certain cell.

Design your data entry table as structured one - data in columns where every column is destined for certain type of information, and all data from one batch in single row. P.e. you have a table with columns
Person Date TransactionNo TransactionType Amount

and one transaction will be a row in this table. It is up to you, allow you several transactions for same person on same day or not. NB! Person and date must be filled for every row!

To ensure you make no typos entering persons, add a worksheet where you register all persons, and use it as source for data validation list in data entry table - you can select persons entered on Persons sheet, and you can't enter ones missing from there.

To get sums you have several options.

a) Design one or several report sheets, which read data from Persons sheet and from data entry sheet;
b) On data entry sheet, at top of sheet add a couple empty rows, and in topmost one calculate the sum of filtered amounts using SUBTOTAL function. Set autofilter on data entry table, and you can calculate sum of amounts for any combination of Persons and dates setting autofilter for table;
c) On Persons sheet, add a column for Amount, and a separate cell where you can enter a date. Use SUMIFS formula to calculate total amount for every person for date, entered into this cell. Or have 2 cells for dates, and calculate total amounts for period defined with those dates.