Unfortunately I still can not get that to work.
my formula is
=(SUMPRODUCT((E2:E336<"")/COUNTIF(E2:E336,E2:E336&""))+2&" different
scorers")
How do I incorporate
="this is some text: " & text(a1,"#,##0")
or
="this is some text: " & round(a1,0)
into that to make it work. I either get a value error or the same
answer. :)
--
Quaisne
------------------------------------------------------------------------
Quaisne's Profile:
http://www.excelforum.com/member.php...o&userid=28052
View this thread:
http://www.excelforum.com/showthread...hreadid=501357