Formula help for budgeting spreadsheet

[kulprit]

Hi All,

I have a budget table which I need a little bit of formula help with. So when I select the option of Paid I would like it to deduct the value from the total providing me with the remaining balance. Please see below example of how I would like it to work;

a	b	c	d	e
1	Company	Amount	Paid/Unpaid
2	Utility 1	50	Paid
3	Utility 2	100	Paid
4	Utility 3	150
5	Total	300
6	Remaining	150
7

<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
</tbody>

Can anyone help with the formula of removing the figure from amount when it says Paid from the total figure in order to provide me with the remaining figure?

Many thanks,

 

[shg]

	A​	B​	C​	D​	E​
1​	1​	Company	Amount	Paid/Unpaid
2​	2​	Utility 1	50​	Paid
3​	3​	Utility 2	100​	Paid
4​	4​	Utility 3	150​
5​	6​	Remaining	150​		C5: =SUMIF(D2:D4, "<>Paid", C2:C4)

 

[kulprit]

	A​	B​	C​	D​	E​
1​	1​	Company	Amount	Paid/Unpaid
2​	2​	Utility 1	50​	Paid
3​	3​	Utility 2	100​	Paid
4​	4​	Utility 3	150​
5​	6​	Remaining	150​		C5: =SUMIF(D2:D4, "<>Paid", C2:C4)

<tbody>
</tbody>

Thank you so much! I spent so much time trying to figure this out using the wrong formulas haha. I can see why you have the MVP status

 

[shg]

You're welcome.