How To: Calculate year over year sales via Excel array formula

Calculate year over year sales via Excel array formula

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 (&"").

Just updated your iPhone? You'll find new emoji, enhanced security, podcast transcripts, Apple Cash virtual numbers, and other useful features. There are even new additions hidden within Safari. Find out what's new and changed on your iPhone with the iOS 17.4 update.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest