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???

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!