Excel Help with If formula

[Mightyxr8]

Hi Everybody,

Could I please get some assistance on this spreadsheet I am making? I have two accounts (Core and Capacity) which have there own funds (A5 and C5). 

I would like the table below to be able to subtract funds from the Core and Capacity cells as they get entered. I made a basic formula =IF($B$8="core",$A$5-$E$8) or =IF($C$8="capacity",$A$5-$E$8) which works on a single cell. I would like to be able to work in on multiple cells but I get a VALUE ERROR using this formula =IF($B$8:$B10="core",$A$5-$E$8:$E10).

If there is any advice please let me know. im sure its something quite simple that I am missing,

Cheers

Sean

[#2]

@Mightyxr8 

In E5, that would be:

=A5-SUMIF($B:$B,"Core",$D:$D)

and in G5:

=C5-SUMIF($B:$B,"Capacity",$D:$D)

It's demonstrated in the attached workbook. 

[#3]

@Riny_van_Eekelen 

Thank you very much. I found a work around but have modified to yours. a lot easier.

thanks

sean