Excel Forum
Similar Content
Excel VBA - Create an Array - 3 ways
Tutorial: Ill show you three different ways to create an array in Excel VBA and Macros and how to ge...
Convert Numbers Stored as Text to Numbers in Excel
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situat...
Pass Arguments to a Macro Called from a Button or Sheet in Excel
Tutorial: How to pass arguments and values to macros called from worksheets, buttons, and anything e...



Excel Magic Trick 613: Array Formula Year Over Year Sales Calculation From Dates Listed As Text


Cool Array Formula to add sales for the year from dates entered as text using the SUMPRODUCT and RIGHT functions and Ampersand & join Symbol calculate Year Over Year Sales. Learn abut TRUE FALSE arrays and how numbers and text are different. See two different methods to convert numbers to text (lead apostrophe) and text to numbers (&"").





Got a Question? Ask it Here in the Forum.