answering your own questions?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"DCSwearingen"
wrote in message
...

=sumproduct(--($b$2:$b$366average($b$2:$b$366)*.05),$b$2:$b$366 )


--
DCSwearingen

Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile:
http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=560762