Separating Income and Outflow in a budget

[littlewing52]

Hello,

I am wanting to create a formula (or formulas) to separately track weekly income and outflow based on if the value is a positive or negative number using the same data set.

For example - if the first week in March I spend $100 in groceries and $50 on my electric bill I would enter them as -$100 and -$50 respectively in my budget, and the formula in the cell designated "Weekly outflow" would reflect -$150 for that week. Conversely, if I got paid $1000 the first week of March, I would enter that as written and the formula in the cell designated "Weekly Income" would reflect $1000.

Example attached. See "March" tab.

[Fluff13]

How about, in Q9

Please Login or Register  to view this content.

and in Q10

Please Login or Register  to view this content.

[littlewing52]

Perfect! I was headed down that trail but hadn't tried the "SUMIF" function. Thank you!

[Fluff13]

You're welcome & thanks for the feedback