SUM by color type

  • Thread starter Thread starter Gerard Sanchez
  • Start date Start date
G

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!
 
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
 
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
 
Back
Top