SUM by color type

[Gerard Sanchez]

Hi,

I want to sum cells of certain color. Googled the function
and came up with =colorfunction

=colorfunction($B$1,$B$3:$B$52,TRUE)

Per the example, aside from adding cells from B3 to B52 , I also want to
include range from E3 to E52. How do I include this in the formula?


Thanks a bunch!

 

[Pete_UK]

Without knowing the details of the colorfunction UDF, I would guess
like this:

=colorfunction($B$1,$B$3:$B$52,TRUE)+colorfunction($B$1,$E$3:$E
$52,TRUE)

Hope this helps.

Pete

 

[Gerard Sanchez]

Thanks Pete!

Without knowing the details of the colorfunction UDF, I would guess
like this:

=colorfunction($B$1,$B$3:$B$52,TRUE)+colorfunction($B$1,$E$3:$E
$52,TRUE)

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Gerard - glad that it worked for you.

Pete

 

[Motzarella]

Free addin ASAP Utilities can do this also.

 

[Chip Pearson]

You need to use VBA code to return the ColorIndex of a cell and then
use that value in a SUMIF function. See
http://www.cpearson.com/excel/colors.aspx for complete code and
examples.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)