I have a column of numbers. Some are black, some are red. I cannot sort the
red numbers to a specific section. Is there a way of adding just the red
numbers? I was thinking of placing my cursor in an adjacent column (say
column D) and using some sort of of IF formula like: IF C3= red fonted
number, then place it here, otherwise leave blank.

Anyone with any ideas? Thanks to anyone who takes the time to respond!

Sam