I need help, new to Excel!

%3CLINGO-SUB%20id%3D%22lingo-sub-1558573%22%20slang%3D%22en-US%22%3EI%20need%20help%2C%20new%20to%20Excel!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1558573%22%20slang%3D%22en-US%22%3EI%20am%20trying%20to%20create%20a%20multiple%20person%20budget%20sheet.%20So%20I%20have%20each%20month%20separated%20out%20and%20all%20the%20info%20I%20need%20typed%20in.%20But%20I%20can%20not%20seem%20to%20get%20the%20SUM%20formula%20to%20work%20right%20for%20what%20I%20need%20it%20to%20do.%20I%20have%20attached%20an%20image%20of%20the%20numbers%20and%20how%20I%20am%20writing%20the%20formula.%3CBR%20%2F%3E%3CBR%20%2F%3EBelow%20I%20want%20a%20cell%20with%20the%20total%20of%20the%20eintire%20C%20column%20then%20a%20second%20cell%20I%20want%20to%20add%20up%20only%20the%20black%20font%20numbers%20and%20a%20third%20cell%20to%20add%20up%20only%20the%20purple%20font.%20Is%20that%20possible%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1558573%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1558719%22%20slang%3D%22de-DE%22%3ESubject%3A%20I%20need%20help%2C%20new%20to%20Excel!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1558719%22%20slang%3D%22de-DE%22%3EIf%20you%20could%20send%20a%20worksheet%20(without%20sensitive%20data)%2C%20it%20would%20be%20an%20advantage%20%3CBR%20%2F%3E%20...%20for%20you%20and%20for%20all%20who%20would%20like%20to%20help%20solve%20your%20problem.%20%3CBR%20%2F%3E%20Because%20we%20don't%20know%20which%20constant%20you%20want%20to%20use%20%3CBR%20%2F%3E%20...%20for%20example%20are%20the%20totals%20in%20other%20sheets%20that%20are%20added%20up%3F%20%3CBR%20%2F%3E%20what%20is%20the%20format%20in%20these%20sheets%20or%20cells%3F%20%3CBR%20%2F%3E%20...%20But%20a%20sheet%20would%20be%20an%20advantage%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20Thank%20you%20%3CBR%20%2F%3E%20Nikolino%20I%20%3CBR%20%2F%3E%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1558896%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%2C%20new%20to%20Excel!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1558896%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746017%22%20target%3D%22_blank%22%3E%40Erin_Rodriguez%3C%2FA%3E%26nbsp%3B%20there%20is%20probably%20a%20better%20way%20to%20set%20up%20the%20sheet%20and%20give%20you%20more%20functionality%20and%20be%20easier%20to%20work%20with.%26nbsp%3B%20That%20aside%2C%20my%20first%20question%20to%20you%20is%20why%20are%20some%20purple%20and%20some%20black%3F%26nbsp%3B%20How%20was%20that%20determined%2Fentered%3F%26nbsp%3B%20For%20example%20if%20you%20have%20a%20conditional%20formatting%20rule%20that%20makes%20them%20purple%20then%20you%20can%20use%20that%20same%20basic%20rule%20in%20a%20SUMIF()%20statement%20or%20something%20similar.%26nbsp%3B%20If%20YOU%20are%20formatting%20them%20purple%2Fblack%20as%20you%20enter%20them%20then%20you%20really%20need%20to%20consider%20some%20better%20options.%26nbsp%3B%20you%20could%20have%20another%20column%20that%20would%20indicate%20what%20that%20color%20is%20supposed%20to%20indicate%20(i.e.%20deposit%20or%20withdrawal%20or%20...)%20and%20you%20can%20then%20have%20excel%20work%20for%20you%20and%20do%20the%20coloring%20using%20conditional%20formatting.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20also%20many%20'templates'%20already%20out%20on%20the%20internet.%26nbsp%3B%20you%20might%20want%20to%20do%20a%20search%20and%20see%20if%20you%20find%20one%20you%20like%20or%20maybe%20just%20get%20some%20good%20ideas%20from%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I am trying to create a multiple person budget sheet. So I have each month separated out and all the info I need typed in. But I can not seem to get the SUM formula to work right for what I need it to do. I have attached an image of the numbers and how I am writing the formula.

Below I want a cell with the total of the eintire C column then a second cell I want to add up only the black font numbers and a third cell to add up only the purple font. Is that possible?
2 Replies
If you could send a worksheet (without sensitive data), it would be an advantage
... for you and for all who would like to help solve your problem.
Because we do not know which constant you want to use
... for example are the totals in other sheets that are added up?
what is the format in these sheets or cells?
... however a sheet would be an advantage


Thank you
Nikolino
I know I don't know anything (Socrates)

@Erin_Rodriguez  there is probably a better way to set up the sheet and give you more functionality and be easier to work with.  That aside, my first question to you is why are some purple and some black?  How was that determined/entered?  For example if you have a conditional formatting rule that makes them purple then you can use that same basic rule in a SUMIF() statement or something similar.  If YOU are formatting them purple/black as you enter them then you really need to consider some better options.  you could have another column that would indicate what that color is supposed to indicate (i.e. deposit or withdrawal or ...) and you can then have excel work for you and do the coloring using conditional formatting.  

There are also many 'templates' already out on the internet.  you might want to do a search and see if you find one you like or maybe just get some good ideas from them.