Microsoft Excel While…Wend VBA Loop Statement, ActiveX Button, SumIf, CountIf & GetPivotData Formulas

This book will quickly show users how to use the SumIf, CountIf and GetPivotData formulas in their Microsoft Excel spreadsheets. It’s also important that all users realize or understand that no two people use or write formulas in the same way. When an individual has used formulas for many years, he or she becomes a master of those particular formulas, i.e., there are users who will nestle formulas with other formulas in order to filter for the results that they need or want, because there has never been only one way to use or write a Microsoft Excel formula. This book is a continuation of my “Microsoft Excel Data Formulas to Extract, Pull or Look for Content in Spreadsheets” book that explains how to use the Left, Right, Mid, Trim, Len, Find, Index, If, And, Or, Iserror, Hlookup, Vlookup, Concatenate, Offset, Match, Small and Large formulas in Microsoft Excel spreadsheets. This book also seeks to introduce users to form controls and VBA, i.e., this book is a hybrid; it will cover one VBA While…Wend loop statement, an ActiveX form control button and a few formulas used in Microsoft Excel spreadsheets; however, users should not look for this book to cover all aspects of the three topics, because I’ve already published four separate eBooks to cover each individual topic or subject matter in detail; those eBooks are 1) Option Button, Check Box, Combo Box, List Box, and Spin Button (Spreadsheet Form Controls, 2) Microsoft Excel VBA Codes Are Fun, Simple, and Easy to Learn In One Hour or Less: VBA for Students, Parents, and Professionals (First Edition), 3) Microsoft VBA Loop Statements for Word and Excel Includes Do...Until, While...Wend and For...Next Statement and 4) Data Formulas to Extract, Pull or Look for Content in Spreadsheets. This eBook serves only to give users a very small sample of what is possible using formulas, form controls and/or VBA. If a user likes what he or she sees, reads or learns in this small eBook, the user may want to look for one of my eBooks that relates to one specific topic or subject matter covered in this hybrid, sample eBook.