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...
Getting Data from a UserForm
Tutorial: How to get data from a UserForm in Excel, including from: text inputs (TextBox), list boxe...



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.