Excel Video 358 has another way arrays might make your life easier. I have five clinical measures that I’ve summed and then rounded the result. If I want to round the measures first and then sum the result, you guessed it, arrays can help.
We’ve done several examples where we’ve summed the result of a formula inside an array. Next time we’ll use a different function to find the third next available appointment for a physician. I look forward to seeing you then.
