by Nate Moore | May 13, 2013 | Arrays
Excel Video 356 offers one more complicated formula, but once that formula works, it’s very powerful. We’re going to do an OR criteria in an array today. If you missed Excel Video 355, please take a minute to watch it first. Today’s video will make a lot more sense....
by Nate Moore | May 8, 2013 | Arrays
I hope you don’t have to spend a ton of time rewinding Excel Video 355. The array formula to sum multiple criteria at once is complicated. The SUMIFS formula in Excel Video 185 is a much easier approach to summing a range of data that meets multiple criteria. The...
by Nate Moore | May 6, 2013 | Arrays
Excel Video 354 has a practical example of an array formula. We’ll write a formula that loops through a range of cells to sum the collections if the year equals 2009. The array formula is made up of two parts that might be best understood from the inside out. The...
by Nate Moore | May 1, 2013 | Arrays
Excel Video 353 has our first trick with arrays. I’ll show you a quick way to get the name of range of cells you’ve named using Name Manager, and then we’re off to work. Sometimes this helps and sometimes this doesn’t help, but one of the features of an array is that...
