Excel Forum
Similar Content
How to Use Dates in Excel
Tutorial: Introduction Guide to using Dates in Excel - this tutorial will show you how to input and...
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...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.