Excel Forum



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.