software

Could somebody recommend me a book with some advanced Excel functions. I
don't need a book for beginners and I don't need a book that repeats simple
functions discribed in free Excel help menu.
e.g. I found this formula recently
quot;=SUMPRODUCT(--(B1:B100=1),--(F1:F100=quot;Donequot;))quot; and I wish I found it a
couple of months ago. I knew the quot;sumproductquot; formula, but I did not know
that it could be used this way (I still don't know what quot;--quot; means).
So, maybe somebody knows a book about Excel with interesting problems and
advanced ways to solve them.

Thank you,

Evgeny

Hi!

Here's a good list of books:

contextures.com/xlbooks.html

And this explains the quot;--quot;:

mcgimpsey.com/excel/formulae/doubleneg.html

And this is a very good explanation of Sumproduct:

www.xldynamic.com/source/xld.SUMPRODUCT.html

Biff

quot;Evgenyquot; gt; wrote in message
...
gt; Could somebody recommend me a book with some advanced Excel functions. I
gt; don't need a book for beginners and I don't need a book that repeats
gt; simple
gt; functions discribed in free Excel help menu.
gt; e.g. I found this formula recently
gt; quot;=SUMPRODUCT(--(B1:B100=1),--(F1:F100=quot;Donequot;))quot; and I wish I found it a
gt; couple of months ago. I knew the quot;sumproductquot; formula, but I did not know
gt; that it could be used this way (I still don't know what quot;--quot; means).
gt; So, maybe somebody knows a book about Excel with interesting problems and
gt; advanced ways to solve them.
gt;
gt; Thank you,
gt;
gt; Evgeny