Excel Help with If formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1294442%22%20slang%3D%22en-US%22%3EExcel%20Help%20with%20If%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1294442%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everybody%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20I%20please%20get%20some%20assistance%20on%20this%20spreadsheet%20I%20am%20making%3F%20I%20have%20two%20accounts%20(Core%20and%20Capacity)%20which%20have%20there%20own%20funds%20(A5%20and%20C5).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20the%20table%20below%20to%20be%20able%20to%20subtract%20funds%20from%20the%20Core%20and%20Capacity%20cells%20as%20they%20get%20entered.%20I%20made%20a%20basic%20formula%20%3DIF(%24B%248%3D%22core%22%2C%24A%245-%24E%248)%20or%26nbsp%3B%3DIF(%24C%248%3D%22capacity%22%2C%24A%245-%24E%248)%20which%20works%20on%20a%20single%20cell.%20I%20would%20like%20to%20be%20able%20to%20work%20in%20on%20multiple%20cells%20but%20I%20get%20a%20VALUE%20ERROR%20using%20this%20formula%26nbsp%3B%3CSPAN%3E%3DIF(%24B%248%3A%24B10%3D%22core%22%2C%24A%245-%24E%248%3A%24E10).%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20466px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183271iC4D3F1B39164F755%2Fimage-dimensions%2F466x348%3Fv%3D1.0%22%20width%3D%22466%22%20height%3D%22348%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20there%20is%20any%20advice%20please%20let%20me%20know.%20im%20sure%20its%20something%20quite%20simple%20that%20I%20am%20missing%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3ESean%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1294442%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1294529%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%20with%20If%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1294529%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F615193%22%20target%3D%22_blank%22%3E%40Mightyxr8%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20E5%2C%20that%20would%20be%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DA5-SUMIF(%24B%3A%24B%2C%22Core%22%2C%24D%3A%24D)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eand%20in%20G5%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DC5-SUMIF(%24B%3A%24B%2C%22Capacity%22%2C%24D%3A%24D)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EIt's%20demonstrated%20in%20the%20attached%20workbook.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1294562%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%20with%20If%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1294562%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%20I%20found%20a%20work%20around%20but%20have%20modified%20to%20yours.%20a%20lot%20easier.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3Esean%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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).

 

Capture.PNG

 

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

 

Cheers

Sean

2 Replies
Highlighted

@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. 

 

 

Highlighted

@Riny_van_Eekelen 

 

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

 

thanks

sean