I have a budget sheet with listed expenses when i have made the purchase i turn the txt to red, i want to keep track of what has been spent.
ok hears an example

a1 = £10
a2 = £10
a3 = £25
a4 = £15
a6 = £35
a7 = total of red

i would like a formula to only calculate the red numbers please