I'm gonna try to make it brief, but I have difficulty explaining exactly what I'm trying to accomplish. I'm currently trying to make a custom budget sheet. The formula shown in the image below looks at a bunch of numbers that fall under different categories.

C16 is the category name, let's call it "Transfers". The purple is the column holding different categories, one of them being "Transfers". The teal is the column holding different values, some positive, some negative.
This way, it takes all the values that match up with the category C16 and sums it up. However, the values can both be positive and negative, and I'd like to split it into two different cells, one holding the positive sum, and one holding the negative sum.
Is this possible? Let me know if you require further information.
Aucun commentaire:
Enregistrer un commentaire