Sum based on color (Excel 2003 )

Topic

New Reply

Hi All

I think I saw this before but is unable to find it. I have a column where the numbers for negative numbers are red, positive are
black. How can I sum column values that are black.

thanks in advance

regards, francis

Reply | Quote

Replies

You can use the SUMIF function, for example:

=SUMIF(A1:A100,">0")

Reply | Quote

You may have seen a reference to Chip Pearson’s Color Functions In Excel in this forum, but that probably won’t help in your situation, because the red and black haven’t been set explicitly, but in the number format.

Reply | Quote

Hi Hans

Thank for the formula and for the link . it does help in other tasks.

cheers, francis

Reply | Quote

Now there is one that Excel 2007 can do. Hmmm…Maybe it does have a few perks after all.

Reply | Quote

There are some useful new features in Excel 2007, such as the COUNTIFS and SUMIFS functions that allow multiple criteria.

Reply | Quote

Hans,

Yes, I was just reading about those today on a website. There are about 8 or so new functions, including the ones you mentioned. Had always used the Conditional Sum Wizard, but will have to give these new ones Countifs and Sumifs a try.

Reply | Quote