Eliminate Value with Macro in Excel

[Natbosco03]

Hello,

I am a brand new member and this is my first post. I am creating a finance excel sheet for a credit card that I own. I record all of my transactions and sum these values up according to the bank accounts that I pay my debt through. For example, I have my personal transactions that will come out of my personal checking account. I have personal transactions for my girlfriend which will come out of her personal checking account. I sum these values up and I put a red font "Paid" next to any of the transactions that have been accounted for and paid for by the respective accounts.

My goal is to create something like a macro that basically turns the value into a zero when I paste the red font "Paid" next to it. But I do not want the macro to physically change the value to a zero. I simply want excel to read any value with a red front "Paid" next to it to be read as a value of zero. This will create an updated sum at the bottom of the excel sheet where I have all the totals of the debts according to the accounts.

I really hope this makes sense!

Thank you!

 

[chicagocomputerclasses]

You don't need a macro for this, you can use SUMIF or SUMPRODUCT function instead of your regular SUM.
Something like =SUMPRODUCT(--(RANGOFPOSSIBLEPAIDTEXT<>"Paid"),RANGEOFNUMBERSTOSUMUP)

 

[Natbosco03]

Thank you very much! It worked exactly how I wanted it to! Thank you! You were extremely helpful!