Hi Bob,
i've tryed to use colorindex fuction, (course I copy your VBA to my
workbook), but it's returned #NOME?
My excel is in brazilian portuguese, but I think it is not a problem to run
the fuction, do you have any Idea about this error message?
Regards from Brazil
Marcelo
"Bob Phillips" escreveu:
Can't do it that way, as interior.colorindex is a VBA statement, not a
function. You need to create a UDF to return the colorindex, and then count
the values returned.
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"John" wrote in message
...
I tried to use sumif to sum up values of cells in a row below cells
highlighted with interior colorfilled:
sumif(range1, interior.colorindex=3,range2)
range 1 - row with highlighted cells
interior fill color - red
range 2 - cells in row below containing values to be summed up
the formula returned 0 value.
Anyone who can shed some light?