Activity

Amount Description

570 Beriah

600 Matt

1000 Mike

680 Doug

680 Jared

-2850 Landview Properties (Rent/Sec)

I then have a cell where it sums up the total for each person (using SUMIF), however, for the deductions (like -2850) I need each individual's totals to be reduced by 1/5 of the actual deduction. So if each individual had a balance of $100, and a deduction of $100 was made, each individual would then have a total of $80.

Thanks everyone in advance.