Hi!

For detailed info about the "--", see:

http://xldynamic.com/source/xld.SUMPRODUCT.html

http://mcgimpsey.com/excel/formulae/doubleneg.html

The squiggly brackets: { }

mean that the formula is an array formula. An array formula operates on more
than one element at the same time. Array formulas are handled in a special
way. Normally, when you enter a formula like:

=SUM(A1:A10)

You type the formula in the cell then you hit the ENTER key. Array formulas
are different. You type the formula in the cell then instead of just hitting
the ENTER key you need to use a combination of keys. You MUST hold down the
CTRL key AND the SHIFT key then hit ENTER. So, the combination is
CTRL,SHIFT,ENTER.

When done properly Excel will place the squiggly brackets: { } around the
formula. You can't just type the brackets. You MUST use the key combo. This
also applies whenever you edit an array formula for any reason. You MUST
re-enter it as an array using the key combo.

Biff

"skarbanan" wrote
in message ...

Thank you biff. You did a great job.I odn't know how to thank you.
I have a last request....could you explain me this forumula ?

{=IF(SUMPRODUCT(--(Dates=$B10);--(nomi=$B$6))=COLUMNS($A:A);INDEX(Magazine;SMALL(I F((Dates=$B10)*(nomi=$B$6);ROW(Magazine)-ROW(C$4)+1);COLUMNS($A:A)));"")}
i mean i understand the functions...but i never used this signs "--"
and "{}" when i click on the fomula the "{}" dissapear end another
value comes out...
This is what i don't understand....

Biff thanks again!


--
skarbanan
------------------------------------------------------------------------
skarbanan's Profile:
http://www.excelforum.com/member.php...o&userid=29901
View this thread: http://www.excelforum.com/showthread...hreadid=496084