The brackets at the beginning and end of the function indicate this is an
array function. I could explain how array functions work, but microsoft does
a better job.

http://office.microsoft.com/en-us/as...872901033.aspx

However I will tell you that if you are attempting to edit the array formula
you are working with and are having trouble getting the brackets to re-appear
and have the function work. You need to hit the keystroke combination
<Ctrl + <Shift + <Enter when exiting the formula. This is how you tell
Excel to calculate the formula as an array formula.

"daddioja" wrote:


Another forum user helped me out with this formula. It works great for
my application, but I don't completely understand it. Particularly, I
am unsure of the use of the brackets at the beginning and end of the
formating. Can someone clear this up for me? Thanks, Jason

{=SUM(IF(B2B$2:B$21,1/COUNTIF(B$2:B$21,B$2:B$21)))+1+ROW()/10^10}


--
daddioja
------------------------------------------------------------------------
daddioja's Profile: http://www.excelforum.com/member.php...o&userid=35024
View this thread: http://www.excelforum.com/showthread...hreadid=550439