Help with adding Sum Formula

[coatesy69]

Hi. Could anyone please help with a formula.

We are creating a spreadsheet at work for employees holidays.
If someone puts in a request, the number of days is added to column C until it is approved by a manager

I am trying to add a sum formula to cell D8 which subtracts the number of day's holiday someone has from the Total days allocated in cell B5 and inserts the result into Cell D8 Balance Remaining.
The formula I have so far is =IFERROR(B5-$C$8,"")



1.JPG



Below shows it has taken off the two days. If I copy the formula down it goes wrong.
Another thing I am trying to do is to keep the Balance Remaining column Empty until someone enters a Y in the Approved Column.
It will then show the days left in column C when more days are entered in the cell below


2.JPG

The formula I have is probably completely wrong, so if someone could please point me in the right direction I would be very grateful.

Thanks for looking.

Graham

[jtakw]

Hi,

Does this help, formula copied down:

Excel 2016 (Windows) 64 bit

	B	C	D	E
5	30
6
7
8		2	28	Y
9		3
10		5		N
11		4	24	Y

Sheet: Sheet108

Excel 2016 (Windows) 64 bit

	D
8	=IF(OR(E8={"","N"}),"",B$5-SUMIF(E$8:E8,"Y",C$8:C8))

Sheet: Sheet108

[coatesy69]

Hi.

That is exactly what I was looking for.

Thank you very much for your help

Regards,

Graham