Summing numbers

Hi There

I was wondering if there is a way to have a currency number be positive or negative based on a another cell?

for example

sumif = "expenses" then the number displays as negitive (-1000)

sumif = "income then number would display as positive (1000) with out the nimus?

its a bit more complicated then that. can you take a look at the excel sheet and see the highlighted areas? i basically want that when i type in "expense that when i type in any digit in the amount it automatically makes it negative and when i chose "income" that when i type in the amount it shows positive

Because your dollar amounts are just typed in, there two ways to do this. One is to have one column where you enter the data (say P), and column F will contain a formula like the one I provided that refers to the data you entered.

=IF(C2="Expense",-1,1)*P2

The other way that is more elegant is with a macro that detects any time you change a value in column C or F, and then it updates the sign of the number in column F accordingly. I have attached that solution.

Keep in mind that this macro is specific to a worksheet, and it looks like you're going to add a new worksheet for each month. Therefore this macro has to be copied to each new worksheet.

Im sorry to bother you again, can you show me in a sheet how its done? i dont quite get it and the one you attached doesn't have the formula in it many thanks