I have this little problem:
I'm entering numbers in row B
A1 sums them
what do I have to do to sum the numbers in B1, only if they colored
red
but at the same time they have to be summed in A1
In other words all the numbers are summed in A1 but only red in B1
can anybody help me with this, please

Marcus