Will someone offer some assistance with this pls,

Is it possible to have the result of this formula
=SUM(DynamicRange)/COUNTIF(DynamicRange,"0")displayed as a comment attached
to cell B1? The comment would need to continually update as dynamic data is
changing.

TIA

hi,
maybe by macro. see this site. Debra knows a thing or two
about comments
http://www.contextures.com/xlcomments03.html#Reset


-----Original Message-----
Will someone offer some assistance with this pls,

Is it possible to have the result of this formula
=SUM(DynamicRange)/COUNTIF(DynamicRange,"0")displayed as
a comment attached
to cell B1? The comment would need to continually update
as dynamic data is
changing.

TIA
.

You could try the user defined function posted by Dave Peterson in the
following thread:


http://groups.google.ca/groups?&selm...scapeXSPAM.com

Neal wrote:
Will someone offer some assistance with this pls,

Is it possible to have the result of this formula
=SUM(DynamicRange)/COUNTIF(DynamicRange,"0")displayed as a comment attached
to cell B1? The comment would need to continually update as dynamic data is
changing.

TIA


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Gave you a specific, tested solution at your other posting of this question.

--
Regards,
Tom Ogilvy


"Neal" wrote in message
...
Will someone offer some assistance with this pls,

Is it possible to have the result of this formula
=SUM(DynamicRange)/COUNTIF(DynamicRange,"0")displayed as a comment
attached
to cell B1? The comment would need to continually update as dynamic data
is
changing.

TIA

Tom or Neal,
Where is the other posting of this question? I'm trying to do
something very similar but don't want to start a new post of something
already answered.

Thanks


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=343185

Don't see your question
But maybe you can find it here
http://www.contextures.com/xlcomments01.html


--
Regards Ron de Bruin
http://www.rondebruin.nl


"bhofsetz" wrote in message
...

Tom or Neal,
Where is the other posting of this question? I'm trying to do
something very similar but don't want to start a new post of something
already answered.

Thanks


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=343185