about "GET.CELL"(cel interior color)

[tom taol]

there are d16~d28 cells of cell interior color.
Three(d16,d19,d26) of them have yellow color.
i wanna know count of yellow using xl formula
i wanna make xl embedded formula in d29 cell.

i did as follow.
name definition macro function == =GET.CELL(38,Sheet1!$D16)
name is "yel"
formula in e16~e28 are =yel respectively, thus e16~e28 cell have 0, 40,
6, 3, 5 and so on.
and then
d29 cell, =COUNTIF(E16:E28,6)
but i don't wanna use E column.
at once, i wanna compose the formula in d29 cell using macro function in
name definition without VBA.

how???

 

[Bob Phillips]

The GET. facility is not recommended, it can cause Excel to crash.

VBA is the best way to go. There is an example on
http://xldynamic.com/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)