How to sum a column when adjacent cells are marked as paid?
So when I mark a cell as paid, I would like the values next to it added up at the bottom
[Re-Titled by Moderator]
iPad, iPadOS 18
Question marked as
Easy: SUMIF()
SUMIF() takes three arguments - a range to check (in this case, your Paid/Not Paid column), a comparison (e.g it equals "Paid"), and a range to sum.
For each cell in the search range, its value is compared to the comparison. For each match, SUMIF() adds the corresponding value from the value range.
So in this case, something like:
=SUMIF(B,"Paid",A)
looks at all the values in column B, if they say "Paid", it sums the corresponding value from column A.