Jump to content

Missing formula: Excel 2016 expert skills for windows pg 51 (Sidebar)

1 reply to this topic

#1 Guest_Jeannie_*

  • Guests

Posted 11 March 2017 - 12:48 AM

Hi There,

I just bought your Expert book and just started the course.  I came across a missing formula on page 51 under note at the very bottom.  Lesson 1-12: Convert a range into a table.


it is missing a formula  =SUBTOTAL(9,[Value])


Thank you.

Love the book.  I should have taken this course ages ago!





#2 Mike


    Advanced Member

  • Administrators
  • 190 posts

Posted 11 March 2017 - 07:52 PM

Dear Jeannie


Thank you for taking the time to report this error.  The sidebar on page 51 had truncated the last time and you are correct, the formula that was truncated is = SUBTOTAL(9. [Value]).


This has now been corrected and will appear correctly in all future print runs of the book.


Best Regards


Mike Smart

Mike Smart is the author of ten world best-selling Excel books. The books are available in printed form for for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Mike has also recorded over 850 video lessons (that you can watch online) for Excel 2007, Excel 2010 and Excel 2013.
Mike Smart is also part of the team that answers questions posted on the ExcelCentral.com forums.

Reply to this topic


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users