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