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!

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)


"tom taol" wrote in message
...

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!