New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 613th installment in their series of digital spreadsheet magic tricks, you'll learn how to
add sales for the year from dates entered as text using the SUMPRODUCT and RIGHT functions and ampersand (&) join symbol. 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 (&"").
Home
Microsoft Office How to Calculate year over year sales via Excel array formula
By getexcellent
May 31, 2010 02:30 PM
You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.
Sign up for Gadget Hacks Weekly and start unlocking your phone's full potential.
Comments
Be the first, drop a comment!