I know this has to be a fairly common question but I have looked for a few days on a resolution and I can't find anything. My problem is that I used a template to calculate a nonprofit groups contributions. It has a general tab that shows the totals. But the next tab has a revenue spot and an expendurature spot. My problem is that my individual contributors owe at times a certain portion of the expendurature of a certain item and I cannot put a negative number in the revenue column and have it reflect in the total profit of that person. For example person A participated in a fundraiser that costs $20.00, they brought in 200.00, thus their individual profit was 180.00. So I tried to enter the negative 20 into the revenue column but it won't calculate the negative number in the totals. It just shows up as 200.00 profit. How do I insert a function to calculate the negative income in the total amount?