Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

trying to create a spreadsheet in numbers that lets me put down the total of how much my team needs to make but also shows the progress of how much is left or how much is raised.

Posted on

Spreadsheets are good for that sort of task. Do you have any specifics on how you want it to look?

SG

Apr 22, 2018 6:25 PM

Names on the left. Total each person has to make in second column. How much they have deposited towards the trip in every following column.

Apr 23, 2018 1:04 AM

Hi Samuel,

Numbers works well with several tables, each with a purpose. Perhaps this will do what you want.

Assuming that the cost of a trip is the same for everybody (\$250.00) you can enter that into the single-cell table named "Cost".

In the "Payments" table, enter each payment. That table contains no formulas. Column A is a Header Column. Row 1 is a Header Row.

The work is done by the "Result" table. Column A is a Header Column. Row 1 is a Header Row.

Formula in B2 ("Total Paid") and Fill Down =SUM(Payments::2:2)

The formula will automatically expand to include extra columns in the "Payments" table.

Formula in C2 ("Owing") and Fill Down =Cost::A\$1−B2

The \$ symbol in the formula keeps it absolute (focused on row 1 of the "Cost" table) as you fill the formula down in the "Result" table.

Regards,

Ian.

Apr 23, 2018 2:26 AM

User profile for user: SamuelSeda